APPS.INV_MWB_LOCATION_TREE dependencies on INV_CACHE

Line 599: l_return_val := inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_inventory_item_id);

595:
596: --START Bug7462485
597: IF (inv_mwb_globals.g_inventory_item_id IS NOT NULL) THEN --bug 8920503
598:
599: l_return_val := inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_inventory_item_id);
600: IF l_return_val THEN
601:
602: l_lot_control := inv_cache.item_rec.lot_control_code;
603: l_rev_control := inv_cache.item_rec.revision_qty_control_code;

Line 602: l_lot_control := inv_cache.item_rec.lot_control_code;

598:
599: l_return_val := inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_inventory_item_id);
600: IF l_return_val THEN
601:
602: l_lot_control := inv_cache.item_rec.lot_control_code;
603: l_rev_control := inv_cache.item_rec.revision_qty_control_code;
604: l_serial_control:= inv_cache.item_rec.serial_number_control_code;
605:
606: END IF;

Line 603: l_rev_control := inv_cache.item_rec.revision_qty_control_code;

599: l_return_val := inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_inventory_item_id);
600: IF l_return_val THEN
601:
602: l_lot_control := inv_cache.item_rec.lot_control_code;
603: l_rev_control := inv_cache.item_rec.revision_qty_control_code;
604: l_serial_control:= inv_cache.item_rec.serial_number_control_code;
605:
606: END IF;
607: END IF;

Line 604: l_serial_control:= inv_cache.item_rec.serial_number_control_code;

600: IF l_return_val THEN
601:
602: l_lot_control := inv_cache.item_rec.lot_control_code;
603: l_rev_control := inv_cache.item_rec.revision_qty_control_code;
604: l_serial_control:= inv_cache.item_rec.serial_number_control_code;
605:
606: END IF;
607: END IF;
608:

Line 1158: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

1154: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
1155:
1156: -- Onhand Material Status Support
1157: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1158: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1159: l_default_status_id := inv_cache.org_rec.default_status_id;
1160: end if;
1161:
1162: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

1155:
1156: -- Onhand Material Status Support
1157: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1158: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1159: l_default_status_id := inv_cache.org_rec.default_status_id;
1160: end if;
1161:
1162: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
1163: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

Line 1162: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

1158: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1159: l_default_status_id := inv_cache.org_rec.default_status_id;
1160: end if;
1161:
1162: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
1163: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1164: l_serial_controlled := 1; -- Item is serial controlled
1165: end if;
1166:

Line 1163: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

1159: l_default_status_id := inv_cache.org_rec.default_status_id;
1160: end if;
1161:
1162: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
1163: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1164: l_serial_controlled := 1; -- Item is serial controlled
1165: end if;
1166:
1167: if (inv_cache.item_rec.lot_control_code <> 1) then

Line 1167: if (inv_cache.item_rec.lot_control_code <> 1) then

1163: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1164: l_serial_controlled := 1; -- Item is serial controlled
1165: end if;
1166:
1167: if (inv_cache.item_rec.lot_control_code <> 1) then
1168: l_lot_controlled := 1; -- Item is lot controlled
1169: end if;
1170: end if;
1171:

Line 1788: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

1784: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
1785:
1786: -- Onhand Material Status Support
1787: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1788: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1789: l_default_status_id := inv_cache.org_rec.default_status_id;
1790: end if;
1791:
1792: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

1785:
1786: -- Onhand Material Status Support
1787: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
1788: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1789: l_default_status_id := inv_cache.org_rec.default_status_id;
1790: end if;
1791:
1792: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
1793: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

Line 1792: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

1788: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1789: l_default_status_id := inv_cache.org_rec.default_status_id;
1790: end if;
1791:
1792: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
1793: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1794: l_serial_controlled := 1; -- Item is serial controlled
1795: end if;
1796:

Line 1793: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

1789: l_default_status_id := inv_cache.org_rec.default_status_id;
1790: end if;
1791:
1792: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
1793: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1794: l_serial_controlled := 1; -- Item is serial controlled
1795: end if;
1796:
1797: if (inv_cache.item_rec.lot_control_code <> 1) then

Line 1797: if (inv_cache.item_rec.lot_control_code <> 1) then

1793: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
1794: l_serial_controlled := 1; -- Item is serial controlled
1795: end if;
1796:
1797: if (inv_cache.item_rec.lot_control_code <> 1) then
1798: l_lot_controlled := 1; -- Item is lot controlled
1799: end if;
1800: end if;
1801:

Line 2229: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

2225: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
2226:
2227: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
2228:
2229: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2230: l_default_status_id := inv_cache.org_rec.default_status_id;
2231: end if;
2232:
2233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);

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

2226:
2227: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org id' ||inv_mwb_globals.g_tree_organization_id );
2228:
2229: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2230: l_default_status_id := inv_cache.org_rec.default_status_id;
2231: end if;
2232:
2233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
2234:

Line 2235: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

2231: end if;
2232:
2233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
2234:
2235: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
2236: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
2237: l_serial_controlled := 1; -- Item is serial controlled
2238: end if;
2239: end if;

Line 2236: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

2232:
2233: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'org status id' || l_default_status_id);
2234:
2235: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
2236: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
2237: l_serial_controlled := 1; -- Item is serial controlled
2238: end if;
2239: end if;
2240: