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_TREE1 dependencies on MTL_ONHAND_TOTAL_MWB_V

Line 2259: table_required := ' mtl_onhand_total_mwb_v v ';

2255:
2256: IF NVL(inv_mwb_globals.g_chk_receiving,0) = 1 THEN
2257: table_required := ' mtl_rcv_mwb_onhand_v v ';
2258: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
2259: table_required := ' mtl_onhand_total_mwb_v v ';
2260: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
2261: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
2262: END IF;
2263: ELSE

Line 2906: table_required := ' mtl_onhand_total_mwb_v v ';

2902: AND inv_mwb_globals.g_lpn_to IS NULL
2903: AND nvl(inv_mwb_globals.g_prepacked,1) = 1
2904: ) THEN
2905: IF (inv_mwb_globals.g_status_id IS NULL) THEN
2906: table_required := ' mtl_onhand_total_mwb_v v ';
2907: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
2908: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
2909: ELSE
2910: table_required := ' mtl_onhand_total_v v ';

Line 4007: FROM mtl_onhand_total_mwb_v

4003: SELECT mp.organization_id, mp.organization_code
4004: INTO org_id,org_code
4005: FROM mtl_parameters mp
4006: WHERE EXISTS (SELECT organization_id
4007: FROM mtl_onhand_total_mwb_v
4008: WHERE 1 = 1 AND organization_id = mp.organization_id)
4009: AND mp.organization_id = inv_mwb_globals.g_organization_id
4010: ORDER BY organization_code;
4011: END IF;

Line 4167: table_required := ' mtl_onhand_total_mwb_v v ';

4163: AND NVL(inv_mwb_globals.g_chk_receiving,0) = 1
4164: AND NVL(inv_mwb_globals.g_chk_inbound,0) = 0 THEN
4165: table_required := ' mtl_rcv_mwb_onhand_v v ';
4166: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
4167: table_required := ' mtl_onhand_total_mwb_v v ';
4168: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
4169: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
4170: END IF;
4171: ELSE

Line 4807: table_required := ' mtl_onhand_total_mwb_v v ';

4803: AND inv_mwb_globals.g_lpn_to IS NULL
4804: AND nvl(inv_mwb_globals.g_prepacked,1) = 1
4805: ) THEN
4806: IF (inv_mwb_globals.g_status_id IS NULL) THEN
4807: table_required := ' mtl_onhand_total_mwb_v v ';
4808: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
4809: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
4810: ELSE
4811: table_required := ' mtl_onhand_total_v v ';

Line 5905: FROM mtl_onhand_total_mwb_v

5901: SELECT mp.organization_id, mp.organization_code
5902: INTO org_id,org_code
5903: FROM mtl_parameters mp
5904: WHERE EXISTS (SELECT organization_id
5905: FROM mtl_onhand_total_mwb_v
5906: WHERE 1 = 1 AND organization_id = mp.organization_id)
5907: AND mp.organization_id = inv_mwb_globals.g_organization_id
5908: ORDER BY organization_code;
5909: END IF;

Line 7512: table_required := ' mtl_onhand_total_mwb_v v ';

7508: ) THEN
7509: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
7510: table_required := ' mtl_rcv_mwb_onhand_v v ';
7511: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
7512: table_required := ' mtl_onhand_total_mwb_v v ';
7513: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
7514: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
7515: END IF;
7516: ELSE

Line 8036: table_required := ' mtl_onhand_total_mwb_v v ';

8032: AND inv_mwb_globals.g_lpn_from IS NULL
8033: AND inv_mwb_globals.g_lpn_to IS NULL
8034: ) THEN
8035: IF (inv_mwb_globals.g_status_id IS NULL) THEN
8036: table_required := ' mtl_onhand_total_mwb_v v ';
8037: -- IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
8038: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
8039: -- END IF;
8040: ELSE

Line 9118: table_required := ' mtl_onhand_total_mwb_v v ';

9114: ) THEN
9115: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
9116: table_required := ' mtl_rcv_mwb_onhand_v v ';
9117: ELSIF(inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
9118: table_required := ' mtl_onhand_total_mwb_v v ';
9119: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
9120: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
9121: END IF;
9122: ELSE

Line 9577: table_required := ' mtl_onhand_total_mwb_v v ';

9573: AND inv_mwb_globals.g_lpn_from IS NULL
9574: AND inv_mwb_globals.g_lpn_to IS NULL
9575: ) THEN
9576: IF (inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
9577: table_required := ' mtl_onhand_total_mwb_v v ';
9578: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
9579: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
9580: ELSE
9581: table_required := ' mtl_onhand_total_v v ';

Line 10498: table_required := ' mtl_onhand_total_mwb_v v ';

10494: AND inv_mwb_globals.g_lpn_to IS NULL
10495: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL
10496: ) THEN
10497: IF (inv_mwb_globals.g_status_id IS NULL) THEN
10498: table_required := ' mtl_onhand_total_mwb_v v ';
10499: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
10500: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
10501: END IF;
10502: ELSE

Line 11078: table_required := ' mtl_onhand_total_mwb_v v ';

11074: AND inv_mwb_globals.g_lpn_from IS NULL
11075: AND inv_mwb_globals.g_lpn_to IS NULL
11076: ) THEN
11077: IF (inv_mwb_globals.g_status_id IS NULL) THEN
11078: table_required := ' mtl_onhand_total_mwb_v v ';
11079: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
11080: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
11081: ELSE
11082: table_required := ' mtl_onhand_total_v v ';

Line 14577: table_required := ' mtl_onhand_total_mwb_v v ';

14573: ) THEN
14574: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
14575: table_required := ' mtl_rcv_mwb_onhand_v v ';
14576: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
14577: table_required := ' mtl_onhand_total_mwb_v v ';
14578: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
14579: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
14580: END IF; -- NSRIVAST, INVCONV
14581: ELSE

Line 15233: table_required := ' mtl_onhand_total_mwb_v v ';

15229: ) THEN
15230: query_str := 'SELECT DISTINCT inventory_item_id, item from( ';
15231:
15232: IF (inv_mwb_globals.g_status_id IS NULL) THEN
15233: table_required := ' mtl_onhand_total_mwb_v v ';
15234: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
15235: -- table_required := ' mtl_onhand_new_lpn_v mot '; -- NSRIVAST, INVCONV
15236: ELSE
15237: table_required := ' mtl_onhand_total_v v ';

Line 16776: table_required := ' mtl_onhand_total_mwb_v v ';

16772: ) THEN
16773: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
16774: table_required := ' mtl_rcv_mwb_onhand_v v ';
16775: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
16776: table_required := ' mtl_onhand_total_mwb_v v ';
16777: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
16778: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
16779: END IF;
16780: ELSE

Line 17292: table_required := ' mtl_onhand_total_mwb_v v ';

17288: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL
17289: AND(NVL(inv_mwb_globals.g_prepacked, 1) = 1)
17290: ) THEN
17291: IF (inv_mwb_globals.g_status_id IS NULL) THEN
17292: table_required := ' mtl_onhand_total_mwb_v v ';
17293: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
17294: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
17295: ELSE
17296: table_required := ' mtl_onhand_total_v v ';

Line 18637: table_required := ' mtl_onhand_total_mwb_v v ';

18633: ) THEN
18634: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
18635: table_required := ' mtl_rcv_mwb_onhand_v v ';
18636: ELSIF(inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
18637: table_required := ' mtl_onhand_total_mwb_v v ';
18638: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
18639: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
18640: END IF; -- NSRIVAST, INVCONV
18641: ELSE

Line 19197: table_required := ' mtl_onhand_total_mwb_v v ';

19193: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL
19194: AND nvl(inv_mwb_globals.g_prepacked,1) = 1
19195: ) THEN
19196: IF (inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
19197: table_required := ' mtl_onhand_total_mwb_v v ';
19198: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
19199: -- table_required := ' mtl_onhand_new_lpn_v moq '; -- NSRIVAST, INVCONV
19200: ELSE
19201: table_required := ' mtl_onhand_total_v v ';