APPS.PORCPTWF dependencies on PO_HEADERS_ALL

Line 1133: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;

1129: --
1130: x_po_number VARCHAR2(20):= NULL;
1131: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := NULL;
1132: x_exp_receipt_date DATE;
1133: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
1134: x_buyer_id NUMBER := 0;
1135:
1136: -- line info
1137: --

Line 1328: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;

1324: -- Header info
1325: x_so_number VARCHAR2(20):= NULL;
1326: x_so_header_id NUMBER;
1327: x_exp_receipt_date DATE;
1328: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
1329:
1330: -- line info
1331: x_line_disp NUMBER := 0;
1332: x_total_lines NUMBER := 0;

Line 2178: from po_headers_all

2174: where rownum < 2;
2175:
2176: cursor getorgid is
2177: select org_id
2178: from po_headers_all
2179: where po_header_id = x_header_id;
2180:
2181: cursor getorgid_int is
2182: select org_id

Line 3103: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;

3099: x_number VARCHAR2(20):= NULL;
3100: x_supplier_name PO_VENDORS.VENDOR_NAME%TYPE := NULL;
3101: x_due_date DATE;
3102: x_buyer_name WF_USERS.DISPLAY_NAME%TYPE := NULL;
3103: x_note_to_receiver PO_HEADERS_ALL.NOTE_TO_RECEIVER%TYPE :=NULL;
3104: x_disp_count NUMBER := 0;
3105: x_confirm_rcpt_inst VARCHAR2(2000);
3106: x_is_int_req VARCHAR2(1);
3107:

Line 3659: FROM POR_RCV_ALL_ITEMS_V1 rcv, po_headers_all poh

3655:
3656: SELECT rcv.po_distribution_id,
3657: rcv.quantity_invoiced,
3658: rcv.quantity_delivered
3659: FROM POR_RCV_ALL_ITEMS_V1 rcv, po_headers_all poh
3660: WHERE poh.PO_HEADER_ID = x_po_header_id AND rcv.po_header_ID = x_po_header_ID
3661: AND rcv.requestor_ID = x_requester_ID
3662: AND ((rcv.expected_receipt_date is not null
3663: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))

Line 3685: FROM POR_RCV_ALL_ITEMS_V1 rcv, po_headers_all poh

3681:
3682: SELECT rcv.po_distribution_id,
3683: rcv.quantity_invoiced,
3684: rcv.quantity_delivered
3685: FROM POR_RCV_ALL_ITEMS_V1 rcv, po_headers_all poh
3686: WHERE poh.PO_HEADER_ID = x_po_header_id AND rcv.po_header_ID = x_po_header_ID
3687: AND rcv.requestor_ID = x_requester_ID
3688: AND ((rcv.expected_receipt_date is not null
3689: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))