Doyen System Pvt. Ltd.
Showing posts with label
PO
.
Show all posts
Showing posts with label
PO
.
Show all posts
Wednesday, 2 January 2019
Script for getting PO SLA Details
›
SELECT DISTINCT pap.last_name || ', ' || pap.first_name AS "BUYER", prh.segment1 AS "REQUISITION...
1 comment:
Script to extract Goods Received Date for Suppliers along with Invoice and PO Information
›
select (select hou.name from apps.hr_operating_units hou where organization_id = (select org_id from apps.ap_invoices_all apa where apa.ve...
1 comment:
Tuesday, 26 September 2017
Script to Update Preparer/ Requester in Requisitions using API
›
Get data to be modified from customer and load it into a staging table. Use this table in the below script to update Preparer/ Requester fo...
2 comments:
Thursday, 29 September 2016
Calculate PO Balances
›
-- Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header_id,...
2 comments:
›
Home
View web version
