APPS.INVIDIT1 dependencies on INV_ITEM_UTIL

Line 207: if ( INV_Item_Util.g_Appl_Inst.fa <> 0 ) then

203: END IF;
204:
205: -- Get asset category flex structure
206: --
207: if ( INV_Item_Util.g_Appl_Inst.fa <> 0 ) then
208: BEGIN
209:
210: select category_flex_structure
211: into X_category_flex_structure

Line 244: --IF ( INV_Item_Util.g_Appl_Inst.WMS <> 0 ) THEN

240:
241: --Jalaj Srivastava Bug 5934365
242: --No need to check for wms install for lot status
243: --material status in R12 is core INV functionality.
244: --IF ( INV_Item_Util.g_Appl_Inst.WMS <> 0 ) THEN
245:
246: IF ( c_default_lot_status_id is not null ) THEN
247: BEGIN
248: SELECT status_code

Line 281: if ( INV_Item_Util.g_Appl_Inst.po <> 0 ) then

277:
278: --END IF;
279: -- Get defaults for purchasing attributes
280: --
281: if ( INV_Item_Util.g_Appl_Inst.po <> 0 ) then
282: BEGIN
283: select DECODE(ORG_INFORMATION_CONTEXT,
284: 'Accounting Information',
285: TO_NUMBER(ORG_INFORMATION3),

Line 671: if ( INV_Item_Util.g_Appl_Inst.po <> 0 ) then

667: BEGIN
668:
669: -- For each product that is fully installed, resolve foreign key references
670: --
671: if ( INV_Item_Util.g_Appl_Inst.po <> 0 ) then
672:
673: if (X_buyer_id is not null) then
674: --Modifying the procedure to query buyers from other organisations when the profile is Y
675: --For bug no. 3845910- Anmurali

Line 725: if ( INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then

721: end if;
722:
723: end if; -- po_installed
724:
725: if ( INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then
726:
727: if (X_picking_rule_id is not null) then
728: begin
729: -- Start of changes for bug12898193

Line 779: if ( INV_Item_Util.g_Appl_Inst.ar <> 0 ) then

775: end if;
776:
777: end if; -- ONT installed
778:
779: if ( INV_Item_Util.g_Appl_Inst.ar <> 0 ) then
780:
781: if (X_accounting_rule_id is not null) then
782: begin
783: select name

Line 807: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 ) then

803: end if;
804:
805: end if; -- ar_installed
806:
807: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 ) then
808:
809: if (X_atp_rule_id is not null) then
810: begin
811: select rule_name

Line 838: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or

834: end if;
835:
836: end if; -- inv_installed
837:
838: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or
839: INV_Item_Util.g_Appl_Inst.po <> 0 ) then
840:
841: if (X_weight_uom_code is not null) then
842: begin

Line 839: INV_Item_Util.g_Appl_Inst.po <> 0 ) then

835:
836: end if; -- inv_installed
837:
838: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or
839: INV_Item_Util.g_Appl_Inst.po <> 0 ) then
840:
841: if (X_weight_uom_code is not null) then
842: begin
843: select unit_of_measure_tl

Line 867: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or

863: end if;
864:
865: end if; -- inv or po installed
866:
867: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or
868: INV_Item_Util.g_Appl_Inst.po <> 0 or
869: INV_Item_Util.g_Appl_Inst.ar <> 0 or
870: INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then
871:

Line 868: INV_Item_Util.g_Appl_Inst.po <> 0 or

864:
865: end if; -- inv or po installed
866:
867: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or
868: INV_Item_Util.g_Appl_Inst.po <> 0 or
869: INV_Item_Util.g_Appl_Inst.ar <> 0 or
870: INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then
871:
872: if (X_item_type is not null) then

Line 869: INV_Item_Util.g_Appl_Inst.ar <> 0 or

865: end if; -- inv or po installed
866:
867: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or
868: INV_Item_Util.g_Appl_Inst.po <> 0 or
869: INV_Item_Util.g_Appl_Inst.ar <> 0 or
870: INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then
871:
872: if (X_item_type is not null) then
873: begin

Line 870: INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then

866:
867: if ( INV_Item_Util.g_Appl_Inst.inv <> 0 or
868: INV_Item_Util.g_Appl_Inst.po <> 0 or
869: INV_Item_Util.g_Appl_Inst.ar <> 0 or
870: INV_Item_Util.g_Appl_Inst.ONT <> 0 ) then
871:
872: if (X_item_type is not null) then
873: begin
874: select meaning

Line 929: if ( INV_Item_Util.g_Appl_Inst.OKS <> 0 ) then -- Contracts Service installed

925: x_uom_class := null;
926: end;
927: end if;
928:
929: if ( INV_Item_Util.g_Appl_Inst.OKS <> 0 ) then -- Contracts Service installed
930:
931: if ( X_coverage_schedule_id is not null ) then
932: begin
933: select name

Line 958: IF ( INV_Item_Util.g_Appl_Inst.INV <> 0 ) THEN

954: X_container_type_dsp := null;
955: end;
956: end if;
957:
958: IF ( INV_Item_Util.g_Appl_Inst.INV <> 0 ) THEN
959:
960: IF ( p_dimension_uom_code is not null ) then
961: BEGIN
962: SELECT unit_of_measure_tl

Line 977: --IF ( INV_Item_Util.g_Appl_Inst.WMS <> 0 ) THEN

973:
974: --Jalaj Srivastava Bug 5934365
975: --No need to check for wms install for lot status
976: --material status in R12 is core INV functionality.
977: --IF ( INV_Item_Util.g_Appl_Inst.WMS <> 0 ) THEN
978:
979: IF ( p_default_lot_status_id is not null ) THEN
980: BEGIN
981: SELECT status_code