APPS.INV_MWB_QUERY_MANAGER dependencies on INV_CACHE

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

542: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
543:
544: -- Onhand Material Status Support
545: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
546: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
547: l_default_status_id := inv_cache.org_rec.default_status_id;
548: end if;
549:
550: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

543:
544: -- Onhand Material Status Support
545: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
546: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
547: l_default_status_id := inv_cache.org_rec.default_status_id;
548: end if;
549:
550: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
551: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

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

546: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
547: l_default_status_id := inv_cache.org_rec.default_status_id;
548: end if;
549:
550: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
551: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
552: l_serial_controlled := 1; -- Item is serial controlled
553: end if;
554:

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

547: l_default_status_id := inv_cache.org_rec.default_status_id;
548: end if;
549:
550: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
551: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
552: l_serial_controlled := 1; -- Item is serial controlled
553: end if;
554:
555: if (inv_cache.item_rec.lot_control_code <> 1) then

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

551: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
552: l_serial_controlled := 1; -- Item is serial controlled
553: end if;
554:
555: if (inv_cache.item_rec.lot_control_code <> 1) then
556: l_lot_controlled := 1; -- Item is lot controlled
557: end if;
558: end if;
559:

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

673: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
674:
675: -- Onhand Material Status Support
676: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
677: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
678: l_default_status_id := inv_cache.org_rec.default_status_id;
679: end if;
680:
681: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

674:
675: -- Onhand Material Status Support
676: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
677: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
678: l_default_status_id := inv_cache.org_rec.default_status_id;
679: end if;
680:
681: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
682: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

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

677: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
678: l_default_status_id := inv_cache.org_rec.default_status_id;
679: end if;
680:
681: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
682: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
683: l_serial_controlled := 1; -- Item is serial controlled
684: end if;
685:

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

678: l_default_status_id := inv_cache.org_rec.default_status_id;
679: end if;
680:
681: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
682: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
683: l_serial_controlled := 1; -- Item is serial controlled
684: end if;
685:
686: if (inv_cache.item_rec.lot_control_code <> 1) then

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

682: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
683: l_serial_controlled := 1; -- Item is serial controlled
684: end if;
685:
686: if (inv_cache.item_rec.lot_control_code <> 1) then
687: l_lot_controlled := 1; -- Item is lot controlled
688: end if;
689: end if;
690:

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

772: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
773:
774: -- Onhand Material Status Support
775: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
776: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
777: l_default_status_id := inv_cache.org_rec.default_status_id;
778: end if;
779:
780: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

773:
774: -- Onhand Material Status Support
775: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
776: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
777: l_default_status_id := inv_cache.org_rec.default_status_id;
778: end if;
779:
780: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
781: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

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

776: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
777: l_default_status_id := inv_cache.org_rec.default_status_id;
778: end if;
779:
780: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
781: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
782: l_serial_controlled := 1; -- Item is serial controlled
783: end if;
784: end if;

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

777: l_default_status_id := inv_cache.org_rec.default_status_id;
778: end if;
779:
780: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
781: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
782: l_serial_controlled := 1; -- Item is serial controlled
783: end if;
784: end if;
785:

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

1965:
1966: -- Onhand Material Status Support
1967: ----------------- Update Status ------------------------------------------
1968:
1969: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1970: l_default_status_id := inv_cache.org_rec.default_status_id;
1971: end if;
1972:
1973: IF l_default_status_id is NOT NULL THEN

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

1966: -- Onhand Material Status Support
1967: ----------------- Update Status ------------------------------------------
1968:
1969: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1970: l_default_status_id := inv_cache.org_rec.default_status_id;
1971: end if;
1972:
1973: IF l_default_status_id is NOT NULL THEN
1974: -- Populating the status column for serial controlled items

Line 2232: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

2228: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
2229:
2230: -- Onhand Material Status Support
2231: if (inv_mwb_globals.g_organization_id is not null) then
2232: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
2233: l_default_status_id := inv_cache.org_rec.default_status_id;
2234: end if;
2235: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2236: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

2229:
2230: -- Onhand Material Status Support
2231: if (inv_mwb_globals.g_organization_id is not null) then
2232: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
2233: l_default_status_id := inv_cache.org_rec.default_status_id;
2234: end if;
2235: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2236: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2237: l_default_status_id := inv_cache.org_rec.default_status_id;

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

2232: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
2233: l_default_status_id := inv_cache.org_rec.default_status_id;
2234: end if;
2235: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2236: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2237: l_default_status_id := inv_cache.org_rec.default_status_id;
2238: end if;
2239: end if;
2240:

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

2233: l_default_status_id := inv_cache.org_rec.default_status_id;
2234: end if;
2235: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2236: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2237: l_default_status_id := inv_cache.org_rec.default_status_id;
2238: end if;
2239: end if;
2240:
2241: CASE p_flag