ORACLE MASTERMINDS

Doyen System Pvt. Ltd.

Showing posts with label Supplier. Show all posts
Showing posts with label Supplier. Show all posts
Sunday, 7 January 2018

Query for Supplier details with banks

›
SELECT                          aps.vendor_name|| ' ~ '|| ass.vendor_site_code "Payee_Identifier"                 ,a...
2 comments:
Tuesday, 2 January 2018

Query to find Suppliers/ Sites with 'Receipt' match option.

›
SELECT     aps.vendor_id,     aps.vendor_name,     DECODE(aps.match_option,'P','Purchase Order','R','Rec...
2 comments:
Wednesday, 21 December 2016

AP Supplier Banks Payments Query

›
SELECT   pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code,          hou.NAME org_name, pv.vendor_id supplier_id,      ...
1 comment:
›
Home
View web version

Contributors

  • Anand Kumar Palanisamy
  • Anand Rajendran
  • Beena Thomas
  • BlazeDream
  • Dhiraj
  • DoyenTeam
  • K Nikethan Reddy
  • Mohan G
  • Prathap Nagarajan
  • Prem Shanker Singh
  • SIVACHANDARAN
  • Tapas Kumar Sathua
  • Unknown
  • Unknown
  • Unknown
  • Unknown
  • Unknown
  • Vimal
  • gopikakuru
Powered by Blogger.