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 1775: table_required := ' mtl_onhand_total_mwb_v v ';

1771:
1772: IF NVL(inv_mwb_globals.g_chk_receiving,0) = 1 THEN
1773: table_required := ' mtl_rcv_mwb_onhand_v v ';
1774: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
1775: table_required := ' mtl_onhand_total_mwb_v v ';
1776: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
1777: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
1778: END IF;
1779: ELSE

Line 2332: table_required := ' mtl_onhand_total_mwb_v v ';

2328: AND inv_mwb_globals.g_lpn_to IS NULL
2329: AND nvl(inv_mwb_globals.g_prepacked,1) = 1
2330: ) THEN
2331: IF (inv_mwb_globals.g_status_id IS NULL) THEN
2332: table_required := ' mtl_onhand_total_mwb_v v ';
2333: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
2334: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
2335: ELSE
2336: table_required := ' mtl_onhand_total_v v ';

Line 3277: FROM mtl_onhand_total_mwb_v

3273: SELECT mp.organization_id, mp.organization_code
3274: INTO org_id,org_code
3275: FROM mtl_parameters mp
3276: WHERE EXISTS (SELECT organization_id
3277: FROM mtl_onhand_total_mwb_v
3278: WHERE 1 = 1 AND organization_id = mp.organization_id)
3279: AND mp.organization_id = inv_mwb_globals.g_organization_id
3280: ORDER BY organization_code;
3281: END IF;

Line 3432: table_required := ' mtl_onhand_total_mwb_v v ';

3428: AND NVL(inv_mwb_globals.g_chk_receiving,0) = 1
3429: AND NVL(inv_mwb_globals.g_chk_inbound,0) = 0 THEN
3430: table_required := ' mtl_rcv_mwb_onhand_v v ';
3431: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
3432: table_required := ' mtl_onhand_total_mwb_v v ';
3433: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
3434: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
3435: END IF;
3436: ELSE

Line 3984: table_required := ' mtl_onhand_total_mwb_v v ';

3980: AND inv_mwb_globals.g_lpn_to IS NULL
3981: AND nvl(inv_mwb_globals.g_prepacked,1) = 1
3982: ) THEN
3983: IF (inv_mwb_globals.g_status_id IS NULL) THEN
3984: table_required := ' mtl_onhand_total_mwb_v v ';
3985: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
3986: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
3987: ELSE
3988: table_required := ' mtl_onhand_total_v v ';

Line 4927: FROM mtl_onhand_total_mwb_v

4923: SELECT mp.organization_id, mp.organization_code
4924: INTO org_id,org_code
4925: FROM mtl_parameters mp
4926: WHERE EXISTS (SELECT organization_id
4927: FROM mtl_onhand_total_mwb_v
4928: WHERE 1 = 1 AND organization_id = mp.organization_id)
4929: AND mp.organization_id = inv_mwb_globals.g_organization_id
4930: ORDER BY organization_code;
4931: END IF;

Line 6320: table_required := ' mtl_onhand_total_mwb_v v ';

6316: ) THEN
6317: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
6318: table_required := ' mtl_rcv_mwb_onhand_v v ';
6319: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
6320: table_required := ' mtl_onhand_total_mwb_v v ';
6321: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
6322: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
6323: END IF;
6324: ELSE

Line 6756: table_required := ' mtl_onhand_total_mwb_v v ';

6752: AND inv_mwb_globals.g_lpn_from IS NULL
6753: AND inv_mwb_globals.g_lpn_to IS NULL
6754: ) THEN
6755: IF (inv_mwb_globals.g_status_id IS NULL) THEN
6756: table_required := ' mtl_onhand_total_mwb_v v ';
6757: -- IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
6758: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
6759: -- END IF;
6760: ELSE

Line 7678: table_required := ' mtl_onhand_total_mwb_v v ';

7674: ) THEN
7675: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
7676: table_required := ' mtl_rcv_mwb_onhand_v v ';
7677: ELSIF(inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
7678: table_required := ' mtl_onhand_total_mwb_v v ';
7679: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
7680: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
7681: END IF;
7682: ELSE

Line 8049: table_required := ' mtl_onhand_total_mwb_v v ';

8045: AND inv_mwb_globals.g_lpn_from IS NULL
8046: AND inv_mwb_globals.g_lpn_to IS NULL
8047: ) THEN
8048: IF (inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
8049: table_required := ' mtl_onhand_total_mwb_v v ';
8050: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
8051: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
8052: ELSE
8053: table_required := ' mtl_onhand_total_v v ';

Line 8815: table_required := ' mtl_onhand_total_mwb_v v ';

8811: AND inv_mwb_globals.g_lpn_to IS NULL
8812: AND inv_mwb_globals.g_tree_serial_attr_query IS NULL
8813: ) THEN
8814: IF (inv_mwb_globals.g_status_id IS NULL) THEN
8815: table_required := ' mtl_onhand_total_mwb_v v ';
8816: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
8817: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
8818: END IF;
8819: ELSE

Line 9307: table_required := ' mtl_onhand_total_mwb_v v ';

9303: AND inv_mwb_globals.g_lpn_from IS NULL
9304: AND inv_mwb_globals.g_lpn_to IS NULL
9305: ) THEN
9306: IF (inv_mwb_globals.g_status_id IS NULL) THEN
9307: table_required := ' mtl_onhand_total_mwb_v v ';
9308: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
9309: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
9310: ELSE
9311: table_required := ' mtl_onhand_total_v v ';

Line 12199: table_required := ' mtl_onhand_total_mwb_v v ';

12195: ) THEN
12196: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
12197: table_required := ' mtl_rcv_mwb_onhand_v v ';
12198: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
12199: table_required := ' mtl_onhand_total_mwb_v v ';
12200: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
12201: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
12202: END IF; -- NSRIVAST, INVCONV
12203: ELSE

Line 12767: table_required := ' mtl_onhand_total_mwb_v v ';

12763: ) THEN
12764: query_str := 'SELECT DISTINCT inventory_item_id, item from( ';
12765:
12766: IF (inv_mwb_globals.g_status_id IS NULL) THEN
12767: table_required := ' mtl_onhand_total_mwb_v v ';
12768: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
12769: -- table_required := ' mtl_onhand_new_lpn_v mot '; -- NSRIVAST, INVCONV
12770: ELSE
12771: table_required := ' mtl_onhand_total_v v ';

Line 14071: table_required := ' mtl_onhand_total_mwb_v v ';

14067: ) THEN
14068: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
14069: table_required := ' mtl_rcv_mwb_onhand_v v ';
14070: ELSIF(inv_mwb_globals.g_status_id IS NULL) THEN
14071: table_required := ' mtl_onhand_total_mwb_v v ';
14072: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
14073: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
14074: END IF;
14075: ELSE

Line 14499: table_required := ' mtl_onhand_total_mwb_v v ';

14495: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL
14496: AND(NVL(inv_mwb_globals.g_prepacked, 1) = 1)
14497: ) THEN
14498: IF (inv_mwb_globals.g_status_id IS NULL) THEN
14499: table_required := ' mtl_onhand_total_mwb_v v ';
14500: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
14501: -- table_required := ' mtl_onhand_new_lpn_v '; -- NSRIVAST, INVCONV
14502: ELSE
14503: table_required := ' mtl_onhand_total_v v ';

Line 15610: table_required := ' mtl_onhand_total_mwb_v v ';

15606: ) THEN
15607: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN
15608: table_required := ' mtl_rcv_mwb_onhand_v v ';
15609: ELSIF(inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
15610: table_required := ' mtl_onhand_total_mwb_v v ';
15611: IF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
15612: table_required := ' mtl_onhand_total_v v '; -- NSRIVAST, INVCONV
15613: END IF; -- NSRIVAST, INVCONV
15614: ELSE

Line 16082: table_required := ' mtl_onhand_total_mwb_v v ';

16078: AND inv_mwb_globals.g_tree_parent_lpn_id IS NULL
16079: AND nvl(inv_mwb_globals.g_prepacked,1) = 1
16080: ) THEN
16081: IF (inv_mwb_globals.g_status_id IS NULL AND inv_mwb_globals.g_only_subinventory_status IS NULL) THEN
16082: table_required := ' mtl_onhand_total_mwb_v v ';
16083: -- ELSIF is_grade_t = TRUE THEN -- NSRIVAST, INVCONV
16084: -- table_required := ' mtl_onhand_new_lpn_v moq '; -- NSRIVAST, INVCONV
16085: ELSE
16086: table_required := ' mtl_onhand_total_v v ';