APPS.XNB_CMN_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 951: --Checks Inventory MTL_SYSTEM_ITEMS_B to see if, for the item

947: -----------------------------------------------------------------------------------------------------------
948: --This procedure checks to see if the Inventory Item of the IB instance, whose details are to be published,
949: --is Provisionable. The current check involves only checking if the item is non-invoicable. Only non-invoicable
950: --items need be sent to the external billing application.
951: --Checks Inventory MTL_SYSTEM_ITEMS_B to see if, for the item
952: -- INVOICEABLE_ITEM_FLAG = "N" - If TRUE the item is to be invoiced by an external biller.
953: --Arguments: Standard workflow function args
954: --Returns: resultout. TRUE if the instance is provisionable (i.e INVOICEABLE_ITEM_FLAG = "N" )
955: -- FALSE if the instance is not provisionable (i.e INVOICEABLE_ITEM_FLAG = "N" )

Line 975: --Hit MTL_SYSTEM_ITEMS_B to see if the Item is invoicable

971: itemtype,
972: itemkey,
973: 'IB_INSTANCE_ID'));
974:
975: --Hit MTL_SYSTEM_ITEMS_B to see if the Item is invoicable
976: SELECT msib.invoiceable_item_flag
977: INTO l_invoiceable_flag
978: FROM mtl_system_items_b msib,
979: csi_item_instances cii

Line 978: FROM mtl_system_items_b msib,

974:
975: --Hit MTL_SYSTEM_ITEMS_B to see if the Item is invoicable
976: SELECT msib.invoiceable_item_flag
977: INTO l_invoiceable_flag
978: FROM mtl_system_items_b msib,
979: csi_item_instances cii
980: WHERE cii.instance_id = l_instance_id
981: AND msib.inventory_item_id = cii.inventory_item_id
982: AND msib.organization_id = cii.inv_master_organization_id;