eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PORCPTWF dependencies on POR_RCV_ALL_ITEMS_V1

Line 191: FROM POR_RCV_ALL_ITEMS_V1 rcv

187: po_distribution_id,
188: null,
189: null,
190: null
191: FROM POR_RCV_ALL_ITEMS_V1 rcv
192: WHERE ((expected_receipt_date is not NULL
193: AND trunc(rcv.expected_receipt_date + 1) <=
194: trunc(SYSDATE))
195: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 222: FROM POR_RCV_ALL_ITEMS_V1 rcv

218: po_distribution_id,
219: null,
220: null,
221: null
222: FROM POR_RCV_ALL_ITEMS_V1 rcv
223: WHERE ((expected_receipt_date is not NULL
224: AND trunc(rcv.expected_receipt_date + 1) <=
225: trunc(SYSDATE))
226: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 347: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;

343: x_revision_num number;
344: x_internal_req_rcpt Varchar2(1) := FND_PROFILE.value('POR_INTERNAL_CONFIRM_RECEIPT');
345: x_sys_date DATE;
346: x_item_key_count number;
347: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
348:
349: BEGIN
350:
351: x_WF_ItemKey := ' ';

Line 383: FROM POR_RCV_ALL_ITEMS_V1 rcv

379: OPEN Porcpt_c for
380: SELECT rcv.po_header_ID, rcv.requestor_ID,
381: rcv.expected_receipt_date, rcv.revision_num,
382: rcv.po_distribution_id, po_num_rel_num
383: FROM POR_RCV_ALL_ITEMS_V1 rcv
384: WHERE ( (rcv.expected_receipt_date is not NULL
385: AND trunc(rcv.expected_receipt_date + 1) <=
386: trunc(SYSDATE)
387: )

Line 408: FROM POR_RCV_ALL_ITEMS_V1 rcv

404: OPEN Porcpt_c for
405: SELECT rcv.po_header_ID, rcv.requestor_ID,
406: rcv.expected_receipt_date, rcv.revision_num,
407: rcv.po_distribution_id, po_num_rel_num
408: FROM POR_RCV_ALL_ITEMS_V1 rcv
409: WHERE ( (rcv.expected_receipt_date is not NULL
410: AND trunc(rcv.expected_receipt_date + 1) <=
411: trunc(SYSDATE)
412: )

Line 1836: FROM POR_RCV_ALL_ITEMS_V1 rcv

1832: po_distribution_id,
1833: null,
1834: null,
1835: null
1836: FROM POR_RCV_ALL_ITEMS_V1 rcv
1837: WHERE ((expected_receipt_date is not NULL
1838: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
1839: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1840: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 1865: FROM POR_RCV_ALL_ITEMS_V1 rcv

1861: po_distribution_id,
1862: null,
1863: null,
1864: null
1865: FROM POR_RCV_ALL_ITEMS_V1 rcv
1866: WHERE ((expected_receipt_date is not NULL
1867: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
1868: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1869: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 1974: FROM POR_RCV_ALL_ITEMS_V1

1970:
1971: if (x_allow_inv_dest_receipts = 'N') then
1972: SELECT count(*)
1973: INTO x_tmp_count
1974: FROM POR_RCV_ALL_ITEMS_V1
1975: WHERE expected_receipt_date is not NULL
1976: AND NVL(receipt_required_flag,'N') = 'Y'
1977: AND destination_type_code = 'EXPENSE'
1978: AND requestor_id is not NULL

Line 1983: FROM POR_RCV_ALL_ITEMS_V1 rcv

1979: AND po_header_ID = x_po_header_ID;
1980:
1981: SELECT count(*)
1982: INTO x_tmp_count1
1983: FROM POR_RCV_ALL_ITEMS_V1 rcv
1984: WHERE ((expected_receipt_date is not NULL
1985: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
1986: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1987: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 2002: FROM POR_RCV_ALL_ITEMS_V1

1998: AND requestor_ID = x_requester_ID;
1999: else
2000: SELECT count(*)
2001: INTO x_tmp_count
2002: FROM POR_RCV_ALL_ITEMS_V1
2003: WHERE expected_receipt_date is not NULL
2004: AND NVL(receipt_required_flag,'N') = 'Y'
2005: AND requestor_id is not NULL
2006: AND po_header_ID = x_po_header_ID;

Line 2010: FROM POR_RCV_ALL_ITEMS_V1 rcv

2006: AND po_header_ID = x_po_header_ID;
2007:
2008: SELECT count(*)
2009: INTO x_tmp_count1
2010: FROM POR_RCV_ALL_ITEMS_V1 rcv
2011: WHERE ((expected_receipt_date is not NULL
2012: AND trunc(to_date(to_char(expected_receipt_date+1), 'DD/MM/YYYY'))<=
2013: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
2014: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 2302: FROM POR_RCV_ALL_ITEMS_V1

2298: OPEN Porcpt_c for
2299: SELECT po_header_ID, requestor_ID,
2300: expected_receipt_date,
2301: revision_num
2302: FROM POR_RCV_ALL_ITEMS_V1
2303: WHERE expected_receipt_date is not NULL
2304: AND expected_receipt_date + 1 <= SYSDATE
2305: AND NVL(receipt_required_flag,'N') = 'Y'
2306: AND destination_type_code = 'EXPENSE'

Line 2314: FROM POR_RCV_ALL_ITEMS_V1

2310:
2311: else
2312: OPEN Porcpt_c for
2313: SELECT po_header_ID, requestor_ID, expected_receipt_date, revision_num
2314: FROM POR_RCV_ALL_ITEMS_V1
2315: WHERE expected_receipt_date is not NULL
2316: AND expected_receipt_date + 1 <= SYSDATE
2317: AND NVL(receipt_required_flag,'N') = 'Y'
2318: AND requestor_ID is not NULL

Line 3252: FROM POR_RCV_ALL_ITEMS_V1

3248: item_description,
3249: currency_code,
3250: unit_price,
3251: po_distribution_id
3252: FROM POR_RCV_ALL_ITEMS_V1
3253: WHERE expected_receipt_date is not NULL
3254: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3255: AND NVL(receipt_required_flag,'N') = 'Y'
3256: AND destination_type_code = 'EXPENSE'

Line 3274: FROM POR_RCV_ALL_ITEMS_V1

3270: item_description,
3271: currency_code,
3272: unit_price,
3273: po_distribution_id
3274: FROM POR_RCV_ALL_ITEMS_V1
3275: WHERE expected_receipt_date is not NULL
3276: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3277: AND NVL(receipt_required_flag,'N') = 'Y'
3278: AND requestor_ID is not NULL

Line 3609: FROM POR_RCV_ALL_ITEMS_V1 rcv

3605:
3606: SELECT rcv.po_distribution_id,
3607: rcv.quantity_invoiced,
3608: rcv.quantity_delivered
3609: FROM POR_RCV_ALL_ITEMS_V1 rcv
3610: WHERE rcv.po_header_ID = x_po_header_ID
3611: AND rcv.requestor_ID = x_requester_ID
3612: AND ((rcv.expected_receipt_date is not null
3613: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))

Line 3634: FROM POR_RCV_ALL_ITEMS_V1 rcv

3630:
3631: SELECT rcv.po_distribution_id,
3632: rcv.quantity_invoiced,
3633: rcv.quantity_delivered
3634: FROM POR_RCV_ALL_ITEMS_V1 rcv
3635: WHERE rcv.po_header_ID = x_po_header_ID
3636: AND rcv.requestor_ID = x_requester_ID
3637: AND ((rcv.expected_receipt_date is not null
3638: AND trunc(rcv.expected_receipt_date + 1) <= trunc(SYSDATE))

Line 3805: FROM POR_RCV_ALL_ITEMS_V1

3801: po_distribution_id,
3802: null,
3803: null,
3804: null
3805: FROM POR_RCV_ALL_ITEMS_V1
3806: WHERE po_header_ID = x_po_header_ID
3807: AND wf_item_key = itemKey;
3808:
3809: FETCH porcpt_Shipment BULK COLLECT into t_po_header_id,

Line 3918: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;

3914: x_sys_date date;
3915: x_exp_receipt_date date;
3916: x_WF_ItemKey varchar2(240);
3917: x_revision_num number;
3918: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
3919: BEGIN
3920: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3921: itemkey => itemkey,
3922: aname => 'PO_HEADER_ID');