eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNB_CMN_PVT dependencies on CSI_ITEM_INSTANCES

Line 979: csi_item_instances cii

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;
983:

Line 997: --Retrieves the Inventory Master Org ID from CSI_ITEM_INSTANCES corresponding to the Instance ID in workflow

993: --This procedure checks to see if the IB instance Owner Account, whose details are to be published, has been
994: --sent to a billing application.
995: --Retrieves the Account Number corresponding to the AccountID, from HZ_CUST_ACCOUNTS.
996: --The retrieved Account Number is set as a workflow Attribute. (Required by the next Workflow Activity)
997: --Retrieves the Inventory Master Org ID from CSI_ITEM_INSTANCES corresponding to the Instance ID in workflow
998: --The retrieved Org ID is set as a worfflow Attribute. (Required by the next Workflow Activity)
999: --Checks for a customer account collaboration with document number = ACCOUNT_NUMBER
1000: -- has been successfully completed with every biller sending atleast one SUCCESS CBOD to the message.
1001: --Arguments: Standard workflow function args

Line 1014: l_instance_id csi_item_instances.instance_id%TYPE;

1010: funcmode IN VARCHAR2,
1011: resultout OUT NOCOPY VARCHAR2)
1012: AS
1013:
1014: l_instance_id csi_item_instances.instance_id%TYPE;
1015: l_inv_org_id csi_item_instances.inv_master_organization_id%TYPE;
1016: l_account_id csi_item_instances.owner_party_account_id%TYPE;
1017: l_account_number hz_cust_accounts.account_number%TYPE;
1018:

Line 1015: l_inv_org_id csi_item_instances.inv_master_organization_id%TYPE;

1011: resultout OUT NOCOPY VARCHAR2)
1012: AS
1013:
1014: l_instance_id csi_item_instances.instance_id%TYPE;
1015: l_inv_org_id csi_item_instances.inv_master_organization_id%TYPE;
1016: l_account_id csi_item_instances.owner_party_account_id%TYPE;
1017: l_account_number hz_cust_accounts.account_number%TYPE;
1018:
1019: l_transaction_type VARCHAR2(5) ; --XML GW Internal Txn Type - XNB

Line 1016: l_account_id csi_item_instances.owner_party_account_id%TYPE;

1012: AS
1013:
1014: l_instance_id csi_item_instances.instance_id%TYPE;
1015: l_inv_org_id csi_item_instances.inv_master_organization_id%TYPE;
1016: l_account_id csi_item_instances.owner_party_account_id%TYPE;
1017: l_account_number hz_cust_accounts.account_number%TYPE;
1018:
1019: l_transaction_type VARCHAR2(5) ; --XML GW Internal Txn Type - XNB
1020: l_transaction_subtype VARCHAR2(5) ; --XML GW Internal Txn Subtype - Owner Outbound

Line 1063: --Get the Inventory Master Organization ID from CSI_ITEM_INSTANCES

1059: itemtype,
1060: itemkey,
1061: 'IB_INSTANCE_ID') );
1062:
1063: --Get the Inventory Master Organization ID from CSI_ITEM_INSTANCES
1064: SELECT inv_master_organization_id
1065: INTO l_inv_org_id
1066: FROM csi_item_instances
1067: WHERE instance_id = l_instance_id;

Line 1066: FROM csi_item_instances

1062:
1063: --Get the Inventory Master Organization ID from CSI_ITEM_INSTANCES
1064: SELECT inv_master_organization_id
1065: INTO l_inv_org_id
1066: FROM csi_item_instances
1067: WHERE instance_id = l_instance_id;
1068:
1069: --Set the Org ID as a workflow attribute
1070: wf_engine.setitemattrtext(