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.RCV_RECEIPT_CONFIRMATION dependencies on WMS_DEPLOY

Line 28: l_wms_deployment_mode VARCHAR2(2);

24: trx_date_from VARCHAR2(100);
25: trx_date_to VARCHAR2(100);
26: l_trx_date_from DATE;
27: l_trx_date_to DATE;
28: l_wms_deployment_mode VARCHAR2(2);
29:
30:
31:
32: CURSOR get_rcv_headers_1(l_trx_date_from DATE, l_trx_date_to DATE) IS

Line 38: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code

34: FROM rcv_shipment_headers rsh,
35: rcv_shipment_lines rsl,
36: rcv_transactions rt
37: WHERE rsh.ship_to_org_id = p_org_id
38: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code
39: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
40: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)
41: AND rsh.shipment_header_id = rt.shipment_header_id
42: AND rt.shipment_line_id = rsl.shipment_line_id

Line 64: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code

60: FROM rcv_shipment_headers rsh,
61: rcv_shipment_lines rsl,
62: rcv_transactions rt
63: WHERE rsh.ship_to_org_id = p_org_id
64: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code
65: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
66: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)
67: AND rt.xml_document_id = p_xml_doc_id
68: AND rsh.shipment_header_id = rt.shipment_header_id

Line 134: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;

130: grh get_rcv_headers_1%ROWTYPE;
131:
132: BEGIN
133:
134: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
135:
136: IF (g_asn_debug = 'Y') THEN
137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);
138: END IF;

Line 137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);

133:
134: l_wms_deployment_mode := wms_deploy.wms_deployment_mode;
135:
136: IF (g_asn_debug = 'Y') THEN
137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);
138: END IF;
139:
140: IF (l_wms_deployment_mode not in ('L','D')) THEN
141: RETURN;

Line 140: IF (l_wms_deployment_mode not in ('L','D')) THEN

136: IF (g_asn_debug = 'Y') THEN
137: asn_debug.put_line('Deployment Mode is '|| l_wms_deployment_mode);
138: END IF;
139:
140: IF (l_wms_deployment_mode not in ('L','D')) THEN
141: RETURN;
142: END IF;
143:
144: IF (g_asn_debug = 'Y') THEN

Line 315: IF (l_wms_deployment_mode = 'L') then

311:
312:
313: IF (xml_doc_id is NULL) THEN
314:
315: IF (l_wms_deployment_mode = 'L') then
316:
317: IF (g_asn_debug = 'Y') THEN
318: asn_debug.put_line('WMS Deploy Mode is LSP');
319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');

Line 318: asn_debug.put_line('WMS Deploy Mode is LSP');

314:
315: IF (l_wms_deployment_mode = 'L') then
316:
317: IF (g_asn_debug = 'Y') THEN
318: asn_debug.put_line('WMS Deploy Mode is LSP');
319: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
320: END IF;
321:
322: UPDATE rcv_transactions rt

Line 340: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);

336: )
337: )
338: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl
339: WHERE rsl.shipment_line_id = rt.shipment_line_id
340: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);
341:
342: ELSE
343:
344: IF (g_asn_debug = 'Y') THEN

Line 345: asn_debug.put_line('WMS Deploy Mode is Distributed');

341:
342: ELSE
343:
344: IF (g_asn_debug = 'Y') THEN
345: asn_debug.put_line('WMS Deploy Mode is Distributed');
346: asn_debug.put_line('Updating rt.receipt_confirmation_extracted flag to P');
347: END IF;
348:
349:

Line 392: IF (l_wms_deployment_mode = 'L') then

388:
389: IF (l_return_status <> rcv_error_pkg.g_ret_sts_success) THEN
390: IF (xml_doc_id is null) THEN
391:
392: IF (l_wms_deployment_mode = 'L') then
393:
394: IF (g_asn_debug = 'Y') THEN
395: asn_debug.put_line('WMS Deploy Mode is LSP');
396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');

Line 395: asn_debug.put_line('WMS Deploy Mode is LSP');

391:
392: IF (l_wms_deployment_mode = 'L') then
393:
394: IF (g_asn_debug = 'Y') THEN
395: asn_debug.put_line('WMS Deploy Mode is LSP');
396: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
397: END IF;
398:
399: UPDATE rcv_transactions rt

Line 418: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);

414: )
415: )
416: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl
417: WHERE rsl.shipment_line_id = rt.shipment_line_id
418: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);
419:
420: ELSE
421:
422: IF (g_asn_debug = 'Y') THEN

Line 423: asn_debug.put_line('WMS Deploy Mode is Distributed');

419:
420: ELSE
421:
422: IF (g_asn_debug = 'Y') THEN
423: asn_debug.put_line('WMS Deploy Mode is Distributed');
424: asn_debug.put_line('Resetting rt.receipt_confirmation_extracted flag to null');
425: END IF;
426:
427: UPDATE rcv_transactions rt