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: select picking_rule_name

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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