APPS.INV_MWB_QUERY_MANAGER dependencies on INV_CACHE

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

577: inv_mwb_query_manager.add_group_clause('moqd.cost_group_id', 'ONHAND');
578:
579: -- Onhand Material Status Support
580: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
581: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
582: l_default_status_id := inv_cache.org_rec.default_status_id;
583: end if;
584:
585: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

578:
579: -- Onhand Material Status Support
580: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
581: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
582: l_default_status_id := inv_cache.org_rec.default_status_id;
583: end if;
584:
585: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
586: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

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

581: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
582: l_default_status_id := inv_cache.org_rec.default_status_id;
583: end if;
584:
585: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
586: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
587: l_serial_controlled := 1; -- Item is serial controlled
588: end if;
589:

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

582: l_default_status_id := inv_cache.org_rec.default_status_id;
583: end if;
584:
585: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
586: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
587: l_serial_controlled := 1; -- Item is serial controlled
588: end if;
589:
590: if (inv_cache.item_rec.lot_control_code <> 1) then

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

586: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
587: l_serial_controlled := 1; -- Item is serial controlled
588: end if;
589:
590: if (inv_cache.item_rec.lot_control_code <> 1) then
591: l_lot_controlled := 1; -- Item is lot controlled
592: end if;
593: end if;
594:

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

708: inv_mwb_query_manager.add_group_clause('moqd.revision', 'ONHAND');
709:
710: -- Onhand Material Status Support
711: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
712: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
713: l_default_status_id := inv_cache.org_rec.default_status_id;
714: end if;
715:
716: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

709:
710: -- Onhand Material Status Support
711: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
712: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
713: l_default_status_id := inv_cache.org_rec.default_status_id;
714: end if;
715:
716: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
717: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

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

712: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
713: l_default_status_id := inv_cache.org_rec.default_status_id;
714: end if;
715:
716: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
717: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
718: l_serial_controlled := 1; -- Item is serial controlled
719: end if;
720:

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

713: l_default_status_id := inv_cache.org_rec.default_status_id;
714: end if;
715:
716: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
717: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
718: l_serial_controlled := 1; -- Item is serial controlled
719: end if;
720:
721: if (inv_cache.item_rec.lot_control_code <> 1) then

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

717: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
718: l_serial_controlled := 1; -- Item is serial controlled
719: end if;
720:
721: if (inv_cache.item_rec.lot_control_code <> 1) then
722: l_lot_controlled := 1; -- Item is lot controlled
723: end if;
724: end if;
725:

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

807: inv_mwb_query_manager.add_group_clause('moqd.lot_number', 'ONHAND');
808:
809: -- Onhand Material Status Support
810: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
811: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
812: l_default_status_id := inv_cache.org_rec.default_status_id;
813: end if;
814:
815: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then

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

808:
809: -- Onhand Material Status Support
810: -- For serial controlled items, the status_id will be populated in post_query of IMVMWQMB.
811: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
812: l_default_status_id := inv_cache.org_rec.default_status_id;
813: end if;
814:
815: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
816: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then

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

811: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
812: l_default_status_id := inv_cache.org_rec.default_status_id;
813: end if;
814:
815: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
816: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
817: l_serial_controlled := 1; -- Item is serial controlled
818: end if;
819: end if;

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

812: l_default_status_id := inv_cache.org_rec.default_status_id;
813: end if;
814:
815: if inv_cache.set_item_rec(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_tree_item_id) then
816: if (inv_cache.item_rec.serial_number_control_code in (2,5)) then
817: l_serial_controlled := 1; -- Item is serial controlled
818: end if;
819: end if;
820:

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

2069:
2070: -- Onhand Material Status Support
2071: ----------------- Update Status ------------------------------------------
2072:
2073: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2074: l_default_status_id := inv_cache.org_rec.default_status_id;
2075: end if;
2076:
2077: IF l_default_status_id is NOT NULL THEN

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

2070: -- Onhand Material Status Support
2071: ----------------- Update Status ------------------------------------------
2072:
2073: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2074: l_default_status_id := inv_cache.org_rec.default_status_id;
2075: end if;
2076:
2077: IF l_default_status_id is NOT NULL THEN
2078: -- Populating the status column for serial controlled items

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

2511: inv_mwb_globals.print_msg(g_pkg_name, l_procedure_name, 'Entered');
2512:
2513: -- Onhand Material Status Support
2514: if (inv_mwb_globals.g_organization_id is not null) then
2515: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
2516: l_default_status_id := inv_cache.org_rec.default_status_id;
2517: end if;
2518: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2519: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

2512:
2513: -- Onhand Material Status Support
2514: if (inv_mwb_globals.g_organization_id is not null) then
2515: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
2516: l_default_status_id := inv_cache.org_rec.default_status_id;
2517: end if;
2518: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2519: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2520: l_default_status_id := inv_cache.org_rec.default_status_id;

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

2515: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
2516: l_default_status_id := inv_cache.org_rec.default_status_id;
2517: end if;
2518: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2519: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2520: l_default_status_id := inv_cache.org_rec.default_status_id;
2521: end if;
2522: end if;
2523:

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

2516: l_default_status_id := inv_cache.org_rec.default_status_id;
2517: end if;
2518: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
2519: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
2520: l_default_status_id := inv_cache.org_rec.default_status_id;
2521: end if;
2522: end if;
2523:
2524: CASE p_flag