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_LPN_TREE dependencies on INV_CACHE

Line 617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

613: END IF;
614: END IF;
615:
616: /*LPN Status Project */
617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
618: l_default_status_id := inv_cache.org_rec.default_status_id;
619: END IF;
620:
621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 618: l_default_status_id := inv_cache.org_rec.default_status_id;

614: END IF;
615:
616: /*LPN Status Project */
617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
618: l_default_status_id := inv_cache.org_rec.default_status_id;
619: END IF;
620:
621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
622:

Line 621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

617: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
618: l_default_status_id := inv_cache.org_rec.default_status_id;
619: END IF;
620:
621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
622:
623: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
624: l_serial_controlled := 1; -- Item is serial controlled
625: END IF;

Line 623: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

619: END IF;
620:
621: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
622:
623: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
624: l_serial_controlled := 1; -- Item is serial controlled
625: END IF;
626:
627: IF (inv_cache.item_rec.lot_control_code <> 1) THEN

Line 627: IF (inv_cache.item_rec.lot_control_code <> 1) THEN

623: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
624: l_serial_controlled := 1; -- Item is serial controlled
625: END IF;
626:
627: IF (inv_cache.item_rec.lot_control_code <> 1) THEN
628: l_lot_controlled := 1; -- Item is lot controlled
629: END IF;
630:
631: END IF;

Line 733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

729: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
730:
731: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');
732:
733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;
736:
737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 734: l_default_status_id := inv_cache.org_rec.default_status_id;

730:
731: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'LPN Status check');
732:
733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;
736:
737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
738: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

Line 737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

733: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;
736:
737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
738: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
739: l_serial_controlled := 1; -- Item is serial controlled
740: END IF;
741:

Line 738: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

734: l_default_status_id := inv_cache.org_rec.default_status_id;
735: END IF;
736:
737: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
738: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
739: l_serial_controlled := 1; -- Item is serial controlled
740: END IF;
741:
742: IF (inv_cache.item_rec.lot_control_code <> 1) then

Line 742: IF (inv_cache.item_rec.lot_control_code <> 1) then

738: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
739: l_serial_controlled := 1; -- Item is serial controlled
740: END IF;
741:
742: IF (inv_cache.item_rec.lot_control_code <> 1) then
743: l_lot_controlled := 1; -- Item is lot controlled
744: END IF;
745: END IF;
746:

Line 980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

976: inv_mwb_query_manager.add_group_clause('wlpn.lpn_id','ONHAND');
977: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
978:
979: /*LPN Status Project */
980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
981: l_default_status_id := inv_cache.org_rec.default_status_id;
982: END IF;
983:
984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 981: l_default_status_id := inv_cache.org_rec.default_status_id;

977: inv_mwb_query_manager.add_group_clause('wlc.cost_group_id','ONHAND');
978:
979: /*LPN Status Project */
980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
981: l_default_status_id := inv_cache.org_rec.default_status_id;
982: END IF;
983:
984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
985:

Line 984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

980: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
981: l_default_status_id := inv_cache.org_rec.default_status_id;
982: END IF;
983:
984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
985:
986: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
987: l_serial_controlled := 1; -- Item is serial controlled
988: END IF;

Line 986: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

982: END IF;
983:
984: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
985:
986: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
987: l_serial_controlled := 1; -- Item is serial controlled
988: END IF;
989:
990: IF (inv_cache.item_rec.lot_control_code <> 1) THEN

Line 990: IF (inv_cache.item_rec.lot_control_code <> 1) THEN

986: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
987: l_serial_controlled := 1; -- Item is serial controlled
988: END IF;
989:
990: IF (inv_cache.item_rec.lot_control_code <> 1) THEN
991: l_lot_controlled := 1; -- Item is lot controlled
992: END IF;
993:
994: END IF;

Line 1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

1095: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id','ONHAND');
1096:
1097: /* LPN Status Project */
1098: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1100: l_default_status_id := inv_cache.org_rec.default_status_id;
1101: END IF;
1102:
1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

Line 1100: l_default_status_id := inv_cache.org_rec.default_status_id;

1096:
1097: /* LPN Status Project */
1098: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1100: l_default_status_id := inv_cache.org_rec.default_status_id;
1101: END IF;
1102:
1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1104: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

Line 1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

1099: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1100: l_default_status_id := inv_cache.org_rec.default_status_id;
1101: END IF;
1102:
1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1104: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1105: l_serial_controlled := 1; -- Item is serial controlled
1106: END IF;
1107:

Line 1104: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1100: l_default_status_id := inv_cache.org_rec.default_status_id;
1101: END IF;
1102:
1103: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1104: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1105: l_serial_controlled := 1; -- Item is serial controlled
1106: END IF;
1107:
1108: IF (inv_cache.item_rec.lot_control_code <> 1) THEN

Line 1108: IF (inv_cache.item_rec.lot_control_code <> 1) THEN

1104: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1105: l_serial_controlled := 1; -- Item is serial controlled
1106: END IF;
1107:
1108: IF (inv_cache.item_rec.lot_control_code <> 1) THEN
1109: l_lot_controlled := 1; -- Item is lot controlled
1110: END IF;
1111: END IF;
1112:

Line 1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

1294: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1295:
1296: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1297:
1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1299: l_default_status_id := inv_cache.org_rec.default_status_id;
1300: END IF;
1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

Line 1299: l_default_status_id := inv_cache.org_rec.default_status_id;

1295:
1296: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1297:
1298: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1299: l_default_status_id := inv_cache.org_rec.default_status_id;
1300: END IF;
1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1303:

Line 1304: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

1300: END IF;
1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1303:
1304: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1305: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1306: l_serial_controlled := 1; -- Item is serial controlled
1307: END IF;
1308: END IF;

Line 1305: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1301:
1302: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1303:
1304: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1305: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1306: l_serial_controlled := 1; -- Item is serial controlled
1307: END IF;
1308: END IF;
1309:

Line 1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

1408: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1409:
1410: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1411:
1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1413: l_default_status_id := inv_cache.org_rec.default_status_id;
1414: END IF;
1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

Line 1413: l_default_status_id := inv_cache.org_rec.default_status_id;

1409:
1410: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
1411:
1412: IF(inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
1413: l_default_status_id := inv_cache.org_rec.default_status_id;
1414: END IF;
1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1417:

Line 1418: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN

1414: END IF;
1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1417:
1418: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1419: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1420: l_serial_controlled := 1; -- Item is serial controlled
1421: END IF;
1422: END IF;

Line 1419: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

1415:
1416: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
1417:
1418: IF inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) THEN
1419: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
1420: l_serial_controlled := 1; -- Item is serial controlled
1421: END IF;
1422: END IF;
1423: