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_ROI_TRANSACTION dependencies on RCV_SHIPMENT_HEADERS

Line 1890: l_asn_type rcv_shipment_headers.asn_type%type;

1886: n IN OUT NOCOPY BINARY_INTEGER
1887: ) IS
1888: po_line_id_record rcv_shipment_line_sv.po_line_id_record_type;
1889: release_id_record rcv_shipment_line_sv.release_id_record_type;
1890: l_asn_type rcv_shipment_headers.asn_type%type;
1891: l_error_column VARCHAR2(30); --Bugfix 4881909
1892: l_is_clm_po VARCHAR2(5) := 'N'; --
1893: BEGIN
1894: IF (g_asn_debug = 'Y') THEN

Line 3448: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;

3444: x_rate NUMBER;
3445: x_allow_rate_override VARCHAR2(1);
3446: /* Bug# 1548597 */
3447: x_secondary_available_qty NUMBER := 0;
3448: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
3449: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
3450: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
3451: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
3452: l_does_asn_exist VARCHAR2(1) := 'N';

Line 4421: rcv_shipment_headers rsh,

4417: l_asn_line_flag
4418: FROM po_line_locations pll,
4419: po_lines pl,
4420: po_headers ph,
4421: rcv_shipment_headers rsh,
4422: rcv_shipment_lines rsl
4423: WHERE rsh.shipment_header_id = temp_cascaded_table(current_n).shipment_header_id
4424: AND rsl.shipment_line_id = temp_cascaded_table(current_n).shipment_line_id
4425: AND rsl.po_header_id = temp_cascaded_table(current_n).po_header_id

Line 4761: FROM rcv_shipment_headers rsh,

4757: */
4758:
4759: SELECT COUNT(*)
4760: INTO l_asn_count
4761: FROM rcv_shipment_headers rsh,
4762: rcv_shipment_lines rsl
4763: WHERE rsh.shipment_header_id = rsl.shipment_header_id
4764: AND NVL(rsh.asn_type, 'STD') IN ('ASN','ASBN') --4287932
4765: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') NOT IN('CANCELLED', 'FULLY RECEIVED')

Line 7404: pre-date the creation_date or shippped_date in rcv_shipment_headers */

7400: RAISE e_validation_error;
7401: END IF;
7402:
7403: /*Bug 6141065: Start: Implemented the validation, Transaction date should not
7404: pre-date the creation_date or shippped_date in rcv_shipment_headers */
7405: IF (x_cascaded_table(n).shipment_num IS NOT NULL AND
7406: x_cascaded_table(n).to_organization_id IS NOT NULL AND
7407: x_cascaded_table(n).transaction_date IS NOT NULL) THEN
7408:

Line 7418: FROM rcv_shipment_headers

7414:
7415: BEGIN
7416: SELECT creation_date, shipped_date
7417: INTO x_creation_date, x_shipped_date
7418: FROM rcv_shipment_headers
7419: WHERE shipment_num = x_cascaded_table(n).shipment_num
7420: AND ship_to_org_id = x_cascaded_table(n).to_organization_id;
7421:
7422: IF (g_asn_debug = 'Y') THEN

Line 7696: X_rsh_freight_carrier_code rcv_shipment_headers.freight_carrier_code%TYPE := '-999999'; /* Bug 8722496 */

7692: PROCEDURE validate_freight_carrier_code(
7693: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
7694: n IN BINARY_INTEGER
7695: ) IS
7696: X_rsh_freight_carrier_code rcv_shipment_headers.freight_carrier_code%TYPE := '-999999'; /* Bug 8722496 */
7697: freight_carrier_record rcv_shipment_line_sv.freight_carrier_record_type;
7698: BEGIN
7699: --validate freight carrier code
7700: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 7708: Internal Orders and Inter-org transfers when rcv_shipment_headers.freight_carrier_code is

7704: IF (x_cascaded_table(n).freight_carrier_code IS NOT NULL) THEN --{
7705:
7706: /*Bug 8722496
7707: Adding IF conditions to ensure that the validation call for freight carriers is not made for
7708: Internal Orders and Inter-org transfers when rcv_shipment_headers.freight_carrier_code is
7709: already populated.
7710: */
7711: BEGIN
7712: IF (x_cascaded_table(n).receipt_source_code IN ('INTERNAL ORDER','INVENTORY')) THEN

Line 7715: FROM rcv_shipment_headers rsh

7711: BEGIN
7712: IF (x_cascaded_table(n).receipt_source_code IN ('INTERNAL ORDER','INVENTORY')) THEN
7713: SELECT Nvl(rsh.freight_carrier_code,'-999')
7714: INTO X_rsh_freight_carrier_code
7715: FROM rcv_shipment_headers rsh
7716: WHERE rsh.shipment_num = x_cascaded_table(n).shipment_num
7717: AND rsh.ship_to_org_id = x_cascaded_table(n).to_organization_id
7718: AND rsh.receipt_source_code IN ('INVENTORY','INTERNAL ORDER');
7719:

Line 10060: DELETE FROM rcv_shipment_headers rsh

10056: SET processing_status_code='ERROR'
10057: WHERE header_interface_id=l_header_interface_id;
10058:
10059: asn_debug.put_line('Deleting the rsh record with shipment_header_id = '||l_ship_head_id);
10060: DELETE FROM rcv_shipment_headers rsh
10061: WHERE shipment_header_id=l_ship_head_id
10062: AND NOT EXISTS (SELECT 1 from rcv_shipment_lines
10063: WHERE shipment_header_id=rsh.shipment_header_id)
10064: AND NOT EXISTS (SELECT 1 from rcv_transactions rt

Line 10076: delete from rcv_shipment_headers rsh

10072: and not exists(select 1 from rcv_transactions_interface
10073: where header_interface_id=l_header_interface_id
10074: and processing_status_code='RUNNING');
10075:
10076: delete from rcv_shipment_headers rsh
10077: where
10078: and not exists(select 1 from rcv_transactions_interface
10079: where shipment_header_id=rsh.shipment_header_id
10080: and processing_status_code='RUNNING');*/

Line 13140: l_asn_type rcv_shipment_headers.asn_type%TYPE; --9534775

13136: ) IS
13137: l_po_header_id po_headers_all.po_header_id%type;
13138: l_return_status VARCHAR2(1) :='S';
13139: l_complex_flag varchar2(1);
13140: l_asn_type rcv_shipment_headers.asn_type%TYPE; --9534775
13141:
13142: BEGIN
13143: IF (g_asn_debug = 'Y') THEN
13144: asn_debug.put_line('enter derive_correction_line ');

Line 13226: from rcv_shipment_headers

13222: /*Bug 9534775 need support wc -ve correction */
13223: IF (l_complex_flag = 'Y') THEN
13224: select asn_type
13225: into l_asn_type
13226: from rcv_shipment_headers
13227: where shipment_header_id = x_cascaded_table(n).shipment_header_id;
13228:
13229: IF( g_asn_debug = 'Y') THEN
13230: asn_debug.put_line('enter l_complex_flag = Y ');

Line 17171: l_lcm_date rcv_shipment_headers.conversion_date%type;

17167: l_sec_rsl_qty NUMBER;
17168: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;
17169: l_lsl_id NUMBER;
17170: v_sobid NUMBER;
17171: l_lcm_date rcv_shipment_headers.conversion_date%type;
17172: p_api_version NUMBER := 1.0;
17173: p_init_msg_list VARCHAR2(1);
17174: p_commit VARCHAR2(1);
17175: x_return_status VARCHAR2(1);