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.INV_MWB_QUERY_MANAGER dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1596: FROM wms_license_plate_numbers

1592: IF rec.lpn_id IS NOT NULL THEN
1593: BEGIN
1594: UPDATE MTL_MWB_GTMP
1595: SET lpn = (SELECT license_plate_number
1596: FROM wms_license_plate_numbers
1597: WHERE lpn_id = rec.lpn_id)
1598: WHERE lpn_id = rec.lpn_id;
1599:
1600: UPDATE MTL_MWB_GTMP

Line 1911: FROM wms_license_plate_numbers

1907: */
1908:
1909: SELECT lpn_context
1910: INTO l_lpn_context_id
1911: FROM wms_license_plate_numbers
1912: WHERE lpn_id = rec.lpn_id;
1913:
1914: UPDATE mtl_mwb_gtmp
1915: SET LPN_CONTEXT = (SELECT meaning

Line 2133: for lpn parameters,added the table wms_license_plate_numbers */

2129: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'wms_enabled_flag '||inv_mwb_globals.g_wms_enabled_flag);
2130: IF inv_mwb_globals.g_wms_enabled_flag = 1 THEN
2131: /*bug13456933,the Query Find Parameters,
2132: if not null,added as the condition,
2133: for lpn parameters,added the table wms_license_plate_numbers */
2134: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2135: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2136: select nvl(sum(wlqv.quantity),0)
2137: into packed_loaded_qty

Line 2138: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn

2134: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2135: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2136: select nvl(sum(wlqv.quantity),0)
2137: into packed_loaded_qty
2138: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn
2139: where wlqv.inventory_item_id = rec.item_id
2140: and wlqv.organization_id = rec.org_id
2141: and wlqv.containerized_flag = 1
2142: and (rec.subinventory_code is null or wlqv.subinventory_code = rec.subinventory_code)

Line 2158: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn

2154: and wlpn.license_plate_number <= nvl(inv_mwb_globals.g_lpn_to,wlpn.license_plate_number);
2155:
2156: select nvl(sum(wlqv.quantity),0)
2157: into unpacked_loaded_qty
2158: from WMS_LOADED_QUANTITIES_V wlqv,wms_license_plate_numbers wlpn
2159: where wlqv.inventory_item_id = rec.item_id
2160: and wlqv.organization_id = rec.org_id
2161: and wlqv.containerized_flag = 2
2162: and (rec.subinventory_code is null or wlqv.subinventory_code = rec.subinventory_code)

Line 2609: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');

2605: END IF;
2606:
2607: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2608: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2609: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');
2610: add_where_clause('wlpn.lpn_context IN (1,9,11)', 'ONHAND');
2611: add_where_clause('moqd.lpn_id = wlpn.lpn_id', 'ONHAND');
2612: END IF;
2613:

Line 2956: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');

2952: */
2953:
2954: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2955: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2956: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');
2957: add_where_clause('msn.lpn_id = wlpn.lpn_id', 'ONHAND');
2958: add_where_clause('wlpn.lpn_context IN (1,9,11)', 'ONHAND');
2959: END IF;
2960:

Line 3209: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ' , p_mat_loc);

3205: END CASE;
3206: END IF;
3207: END IF;
3208: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Adding tables to the query : ' || p_mat_loc);
3209: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ' , p_mat_loc);
3210: inv_mwb_query_manager.add_from_clause(' wms_lpn_contents wlc ', p_mat_loc);
3211: add_where_clause(' wlc.parent_lpn_id = wlpn.lpn_id ', p_mat_loc);
3212:
3213: IF inv_mwb_globals.g_serial_from IS NOT NULL

Line 3644: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');

3640: -- ER(9158529)
3641:
3642: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3643: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3644: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3645: add_where_clause('rs.lpn_id = wlpn.lpn_id', 'RECEIVING');
3646: END IF;
3647:
3648: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3740: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');

3736: -- ER(9158529)
3737:
3738: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3739: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3740: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3741: add_where_clause('msn.lpn_id = wlpn.lpn_id', 'RECEIVING');
3742: END IF;
3743:
3744: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 3900: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');

3896: -- ER(9158529)
3897:
3898: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3899: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3900: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3901: add_where_clause('rs.lpn_id = wlpn.lpn_id', 'RECEIVING');
3902: END IF;
3903:
3904: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 4342: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');

4338: END IF;
4339:
4340: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
4341: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
4342: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');
4343: add_where_clause('rsl.asn_lpn_id = wlpn.lpn_id', 'INBOUND');
4344: END IF;
4345:
4346: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 4519: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');

4515: -- ER(9158529)
4516:
4517: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
4518: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
4519: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');
4520: add_where_clause('rsl.asn_lpn_id = wlpn.lpn_id', 'INBOUND');
4521: END IF;
4522:
4523: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 7100: FROM wms_license_plate_numbers wlpn

7096: l_procedure_name := 'MAKE_NESTED_LPN_QUERY';
7097:
7098: SELECT count(*)
7099: INTO l_count
7100: FROM wms_license_plate_numbers wlpn
7101: WHERE wlpn.parent_lpn_id = inv_mwb_globals.g_tree_parent_lpn_id
7102: AND wlpn.organization_id = inv_mwb_globals.g_tree_organization_id;
7103:
7104: IF l_count > 0 THEN

Line 7111: add_from_clause('wms_license_plate_numbers wlpn', 'ONHAND_1');

7107: inv_mwb_globals.g_is_nested_lpn := 'NO';
7108: RETURN;
7109: END IF;
7110:
7111: add_from_clause('wms_license_plate_numbers wlpn', 'ONHAND_1');
7112: g_onhand_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
7113: 'wlpn.subinventory_code';
7114: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
7115: 'wlpn.locator_id';

Line 7142: FROM wms_license_plate_numbers wlpn

7138: l_procedure_name := 'MAKE_NESTED_LPN_RCV_QUERY';
7139:
7140: SELECT count(*)
7141: INTO l_count
7142: FROM wms_license_plate_numbers wlpn
7143: WHERE wlpn.parent_lpn_id = inv_mwb_globals.g_tree_parent_lpn_id
7144: AND wlpn.organization_id = inv_mwb_globals.g_tree_organization_id;
7145:
7146: IF l_count > 0 THEN

Line 7153: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');

7149: inv_mwb_globals.g_is_nested_lpn := 'NO';
7150: RETURN;
7151: END IF;
7152:
7153: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');
7154: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
7155: 'wlpn.subinventory_code';
7156: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
7157: 'wlpn.locator_id';

Line 7181: FROM wms_license_plate_numbers wlpn

7177: l_procedure_name := 'MAKE_NESTED_LPN_INBOUND_QUERY';
7178:
7179: SELECT count(*)
7180: INTO l_count
7181: FROM wms_license_plate_numbers wlpn
7182: WHERE wlpn.parent_lpn_id = inv_mwb_globals.g_tree_parent_lpn_id
7183: AND wlpn.organization_id = inv_mwb_globals.g_tree_organization_id;
7184:
7185: IF l_count > 0 THEN

Line 7192: add_from_clause('wms_license_plate_numbers wlpn', 'INBOUND_1');

7188: inv_mwb_globals.g_is_nested_lpn := 'NO';
7189: RETURN;
7190: END IF;
7191:
7192: add_from_clause('wms_license_plate_numbers wlpn', 'INBOUND_1');
7193:
7194: g_inbound_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
7195: 'wlpn.subinventory_code';
7196: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=