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 409: FROM POR_RCV_ALL_ITEMS_V1 rcv

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

Line 1839: FROM POR_RCV_ALL_ITEMS_V1 rcv

1835: po_distribution_id,
1836: null,
1837: null,
1838: null
1839: FROM POR_RCV_ALL_ITEMS_V1 rcv
1840: WHERE ((expected_receipt_date is not NULL
1841: AND trunc(expected_receipt_date+1)<= --bug 16556483
1842: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1843: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 1868: FROM POR_RCV_ALL_ITEMS_V1 rcv

1864: po_distribution_id,
1865: null,
1866: null,
1867: null
1868: FROM POR_RCV_ALL_ITEMS_V1 rcv
1869: WHERE ((expected_receipt_date is not NULL
1870: AND trunc(expected_receipt_date+1)<= --bug 16556483
1871: trunc(to_date(x_ntf_trigerred_date, 'DD/MM/YYYY')))
1872: OR EXISTS (SELECT 1 FROM ap_holds aph

Line 1977: FROM POR_RCV_ALL_ITEMS_V1

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

Line 1986: FROM POR_RCV_ALL_ITEMS_V1 rcv

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

Line 2005: FROM POR_RCV_ALL_ITEMS_V1

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

Line 2013: FROM POR_RCV_ALL_ITEMS_V1 rcv

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

Line 2305: FROM POR_RCV_ALL_ITEMS_V1

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

Line 2317: FROM POR_RCV_ALL_ITEMS_V1

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

Line 2581: into l_expDate from POR_RCV_ALL_ITEMS_V1 where po_header_id= l_po_header_id;

2577: itemkey => itemkey,
2578: aname => 'PO_HEADER_ID');
2579:
2580: select expected_receipt_date
2581: into l_expDate from POR_RCV_ALL_ITEMS_V1 where po_header_id= l_po_header_id;
2582: If (l_expDate is NULL
2583: or trunc(l_expDate + 1) <= trunc(SYSDATE))
2584: then
2585: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 3297: FROM POR_RCV_ALL_ITEMS_V1

3293: item_description,
3294: currency_code,
3295: unit_price,
3296: po_distribution_id
3297: FROM POR_RCV_ALL_ITEMS_V1
3298: WHERE expected_receipt_date is not NULL
3299: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3300: AND NVL(receipt_required_flag,'N') = 'Y'
3301: AND destination_type_code = 'EXPENSE'

Line 3319: FROM POR_RCV_ALL_ITEMS_V1

3315: item_description,
3316: currency_code,
3317: unit_price,
3318: po_distribution_id
3319: FROM POR_RCV_ALL_ITEMS_V1
3320: WHERE expected_receipt_date is not NULL
3321: AND trunc(expected_receipt_date) = trunc(x_exp_receipt_date)
3322: AND NVL(receipt_required_flag,'N') = 'Y'
3323: AND requestor_ID is not NULL

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))

Line 3865: FROM POR_RCV_ALL_ITEMS_V1

3861: po_distribution_id,
3862: null,
3863: null,
3864: null
3865: FROM POR_RCV_ALL_ITEMS_V1
3866: WHERE po_header_ID = x_po_header_ID
3867: AND wf_item_key = itemKey;
3868:
3869: FETCH porcpt_Shipment BULK COLLECT into t_po_header_id,

Line 3978: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;

3974: x_sys_date date;
3975: x_exp_receipt_date date;
3976: x_WF_ItemKey varchar2(240);
3977: x_revision_num number;
3978: x_po_num_rel_num POR_RCV_ALL_ITEMS_V1.PO_NUM_REL_NUM%type;
3979: BEGIN
3980: x_po_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
3981: itemkey => itemkey,
3982: aname => 'PO_HEADER_ID');