APPS.INV_MWB_QUERY_MANAGER dependencies on RCV_SHIPMENT_HEADERS

Line 1676: FROM rcv_shipment_headers rsh

1672:
1673: l_mtl_location := document_type_meaning(4);
1674: SELECT shipment_num, shipped_date
1675: INTO l_shipment_num, l_shipped_date
1676: FROM rcv_shipment_headers rsh
1677: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn;
1678:
1679: UPDATE mtl_mwb_gtmp
1680: SET document_number = l_shipment_num

Line 1736: FROM rcv_shipment_headers rsh

1732: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, rec.shipment_header_id_asn);
1733: l_mtl_location := document_type_meaning(3);
1734: UPDATE mtl_mwb_gtmp
1735: SET document_number = (SELECT shipment_num
1736: FROM rcv_shipment_headers rsh
1737: WHERE rsh.shipment_header_id = rec.shipment_header_id_asn)
1738: , document_type = l_mtl_location
1739: , document_type_id = 3
1740: WHERE shipment_header_id_asn = rec.shipment_header_id_asn;

Line 3373: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');

3369: END IF;
3370:
3371: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL
3372: OR inv_mwb_globals.g_tree_doc_type_id IN (3,4) THEN
3373: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3374: add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id', 'INBOUND');
3375: END IF;
3376:
3377: IF inv_mwb_globals.g_shipment_header_id_asn IS NOT NULL THEN

Line 3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');

3492: OR inv_mwb_globals.g_shipment_header_id_interorg IS NOT NULL THEN
3493:
3494: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Interorg tab');
3495:
3496: inv_mwb_query_manager.add_from_clause(' rcv_shipment_headers rsh ','INBOUND');
3497: inv_mwb_query_manager.add_from_clause(' rcv_shipment_lines rsl ','INBOUND');
3498:
3499: inv_mwb_query_manager.add_where_clause(' rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3500: inv_mwb_query_manager.add_where_clause(' rsl.shipment_line_id(+) = ms.shipment_line_id ', 'INBOUND');

Line 3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');

3645: END IF;
3646:
3647: ELSE -- If interorg and supplier tab null
3648:
3649: inv_mwb_query_manager.add_from_clause('rcv_shipment_headers rsh ','INBOUND');
3650: inv_mwb_query_manager.add_from_clause('rcv_shipment_lines rsl ','INBOUND');
3651: inv_mwb_query_manager.add_where_clause('rsh.shipment_header_id(+) = ms.shipment_header_id ', 'INBOUND');
3652: inv_mwb_query_manager.add_where_clause('rsl.shipment_line_id(+) = ms.shipment_line_id', 'INBOUND');
3653: