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 1524: FROM wms_license_plate_numbers

1520: IF rec.lpn_id IS NOT NULL THEN
1521: BEGIN
1522: UPDATE MTL_MWB_GTMP
1523: SET lpn = (SELECT license_plate_number
1524: FROM wms_license_plate_numbers
1525: WHERE lpn_id = rec.lpn_id)
1526: WHERE lpn_id = rec.lpn_id;
1527:
1528: UPDATE MTL_MWB_GTMP

Line 1809: FROM wms_license_plate_numbers

1805: */
1806:
1807: SELECT lpn_context
1808: INTO l_lpn_context_id
1809: FROM wms_license_plate_numbers
1810: WHERE lpn_id = rec.lpn_id;
1811:
1812: UPDATE mtl_mwb_gtmp
1813: SET LPN_CONTEXT = (SELECT meaning

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

2291: END IF;
2292:
2293: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2294: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2295: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');
2296: add_where_clause('wlpn.lpn_context IN (1,9,11)', 'ONHAND');
2297: add_where_clause('moqd.lpn_id = wlpn.lpn_id', 'ONHAND');
2298: END IF;
2299:

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

2571: END IF;
2572:
2573: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
2574: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
2575: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','ONHAND');
2576: add_where_clause('msn.lpn_id = wlpn.lpn_id', 'ONHAND');
2577: add_where_clause('wlpn.lpn_context IN (1,9,11)', 'ONHAND');
2578: END IF;
2579:

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

2786: END CASE;
2787: END IF;
2788: END IF;
2789: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Adding tables to the query : ' || p_mat_loc);
2790: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ' , p_mat_loc);
2791: inv_mwb_query_manager.add_from_clause(' wms_lpn_contents wlc ', p_mat_loc);
2792: add_where_clause(' wlc.parent_lpn_id = wlpn.lpn_id ', p_mat_loc);
2793:
2794: IF inv_mwb_globals.g_serial_from IS NOT NULL

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

3063: END IF;
3064:
3065: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3066: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3067: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3068: add_where_clause('rs.lpn_id = wlpn.lpn_id', 'RECEIVING');
3069: END IF;
3070:
3071: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

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

3127: END IF;
3128:
3129: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3130: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3131: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3132: add_where_clause('msn.lpn_id = wlpn.lpn_id', 'RECEIVING');
3133: END IF;
3134:
3135: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

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

3229: END IF;
3230:
3231: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3232: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3233: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','RECEIVING');
3234: add_where_clause('rs.lpn_id = wlpn.lpn_id', 'RECEIVING');
3235: END IF;
3236:
3237: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

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

3554: END IF;
3555:
3556: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3557: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3558: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');
3559: add_where_clause('rsl.asn_lpn_id = wlpn.lpn_id', 'INBOUND');
3560: END IF;
3561:
3562: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

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

3672: END IF;
3673:
3674: IF inv_mwb_globals.g_lpn_from_id IS NOT NULL
3675: OR inv_mwb_globals.g_lpn_to_id IS NOT NULL THEN
3676: inv_mwb_query_manager.add_from_clause(' wms_license_plate_numbers wlpn ','INBOUND');
3677: add_where_clause('rsl.asn_lpn_id = wlpn.lpn_id', 'INBOUND');
3678: END IF;
3679:
3680: IF (inv_mwb_globals.g_lpn_from_id IS NOT NULL AND

Line 6203: FROM wms_license_plate_numbers wlpn

6199: l_procedure_name := 'MAKE_NESTED_LPN_QUERY';
6200:
6201: SELECT count(*)
6202: INTO l_count
6203: FROM wms_license_plate_numbers wlpn
6204: WHERE wlpn.parent_lpn_id = inv_mwb_globals.g_tree_parent_lpn_id
6205: AND wlpn.organization_id = inv_mwb_globals.g_tree_organization_id;
6206:
6207: IF l_count > 0 THEN

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

6210: inv_mwb_globals.g_is_nested_lpn := 'NO';
6211: RETURN;
6212: END IF;
6213:
6214: add_from_clause('wms_license_plate_numbers wlpn', 'ONHAND_1');
6215: g_onhand_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6216: 'wlpn.subinventory_code';
6217: g_onhand_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6218: 'wlpn.locator_id';

Line 6242: FROM wms_license_plate_numbers wlpn

6238: l_procedure_name := 'MAKE_NESTED_LPN_RCV_QUERY';
6239:
6240: SELECT count(*)
6241: INTO l_count
6242: FROM wms_license_plate_numbers wlpn
6243: WHERE wlpn.parent_lpn_id = inv_mwb_globals.g_tree_parent_lpn_id
6244: AND wlpn.organization_id = inv_mwb_globals.g_tree_organization_id;
6245:
6246: IF l_count > 0 THEN

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

6249: inv_mwb_globals.g_is_nested_lpn := 'NO';
6250: RETURN;
6251: END IF;
6252:
6253: inv_mwb_query_manager.add_from_clause('wms_license_plate_numbers wlpn', 'RECEIVING_1');
6254: g_receiving_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6255: 'wlpn.subinventory_code';
6256: g_receiving_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=
6257: 'wlpn.locator_id';

Line 6281: FROM wms_license_plate_numbers wlpn

6277: l_procedure_name := 'MAKE_NESTED_LPN_INBOUND_QUERY';
6278:
6279: SELECT count(*)
6280: INTO l_count
6281: FROM wms_license_plate_numbers wlpn
6282: WHERE wlpn.parent_lpn_id = inv_mwb_globals.g_tree_parent_lpn_id
6283: AND wlpn.organization_id = inv_mwb_globals.g_tree_organization_id;
6284:
6285: IF l_count > 0 THEN

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

6288: inv_mwb_globals.g_is_nested_lpn := 'NO';
6289: RETURN;
6290: END IF;
6291:
6292: add_from_clause('wms_license_plate_numbers wlpn', 'INBOUND_1');
6293:
6294: g_inbound_1_select(inv_mwb_query_manager.SUBINVENTORY_CODE).column_value :=
6295: 'wlpn.subinventory_code';
6296: g_inbound_1_select(inv_mwb_query_manager.LOCATOR_ID).column_value :=