DBA Data[Home] [Help]

APPS.BOM_DIAGUNITTEST_RTGHLCHK dependencies on MTL_PARAMETERS

Line 47: from mtl_parameters

43:
44: If l_org_id is not null Then /* validate if input org_id exists*/
45: Begin
46: select 1 into l_org_exists
47: from mtl_parameters
48: where organization_id=l_org_id;
49: Exception
50: When others Then
51: l_org_exists :=0;

Line 74: ' from mtl_item_flexfields mif, mtl_rtg_item_revisions mrir, mtl_parameters mp '||

70: ' to_char(mrir.implementation_date,''DD-MON-YYYY HH24:MI:SS'') "Implementation Date", '||
71: ' mrir.change_notice "ECO Number", '||
72: ' mif.inventory_item_id "Item Id", mrir.organization_id "Organization Id", '||
73: ' mrir.revised_item_sequence_id "Revised Item Seq Id" '||
74: ' from mtl_item_flexfields mif, mtl_rtg_item_revisions mrir, mtl_parameters mp '||
75: ' where mif.inventory_item_id=mrir.inventory_item_id '||
76: ' and mif.organization_id =mrir.organization_id '||
77: ' and mp.organization_id =mif.organization_id '||
78: ' and mrir.process_revision is not null '||