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 HZ_CUST_ACCOUNTS

Line 312: FROM hz_cust_accounts

308: BEGIN
309:
310: SELECT cust_account_id
311: INTO l_cust_ac_id
312: FROM hz_cust_accounts
313: WHERE account_number = l_doc_no;
314:
315: SELECT cust_account_id
316: INTO l_temp

Line 497: FROM hz_cust_accounts

493: BEGIN
494:
495: SELECT cust_account_id
496: INTO l_cust_ac_id
497: FROM hz_cust_accounts
498: WHERE account_number = l_doc_no;
499:
500: SELECT cust_account_id
501: INTO l_temp

Line 995: --Retrieves the Account Number corresponding to the AccountID, from HZ_CUST_ACCOUNTS.

991:
992: ------------------------------------------------------------------------------------------------------------
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

Line 1017: l_account_number hz_cust_accounts.account_number%TYPE;

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
1021: l_party_type VARCHAR2(30) ; --XML Gateway Party Type

Line 1043: --Get Account Number from HZ_CUST_ACCOUNTS

1039: itemtype,
1040: itemkey,
1041: 'IB_OWNER_ACCT_ID_NEW') );
1042:
1043: --Get Account Number from HZ_CUST_ACCOUNTS
1044: SELECT account_number
1045: INTO l_account_number
1046: FROM hz_cust_accounts
1047: WHERE cust_account_id = l_account_id;

Line 1046: FROM hz_cust_accounts

1042:
1043: --Get Account Number from HZ_CUST_ACCOUNTS
1044: SELECT account_number
1045: INTO l_account_number
1046: FROM hz_cust_accounts
1047: WHERE cust_account_id = l_account_id;
1048:
1049: --Set the Account Number as a workflow attribute
1050: wf_engine.setitemattrtext(

Line 1422: TYPE AccountNumTyp IS TABLE OF HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE

1418: l_user_id NUMBER;
1419: l_resp_id NUMBER;
1420: l_resp_appl_id NUMBER;
1421:
1422: TYPE AccountNumTyp IS TABLE OF HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE
1423: INDEX BY BINARY_INTEGER;
1424:
1425: l_acc_num AccountNumTyp;
1426:

Line 1455: FROM HZ_CUST_ACCOUNTS

1451:
1452:
1453: SELECT ACCOUNT_NUMBER
1454: INTO l_account_number
1455: FROM HZ_CUST_ACCOUNTS
1456: WHERE CUST_ACCOUNT_ID = l_param_value;
1457:
1458: XNB_DEBUG.log('oracle.apps.ar.hz.CustAccount.update',l_account_number);
1459:

Line 1486: hz_cust_accounts acc

1482:
1483: SELECT account_number
1484: INTO l_account_number
1485: FROM hz_billing_preferences bill_pref,
1486: hz_cust_accounts acc
1487: WHERE bill_pref.cust_account_id = acc.cust_account_id
1488: AND bill_pref.billing_preferences_id = l_param_value;
1489:
1490: XNB_DEBUG.log('oracle.apps.ar.hz.BillingPreference',l_account_number);

Line 1517: FROM HZ_CUST_ACCOUNTS ACCT,

1513: BEGIN
1514:
1515: SELECT distinct ACCT.ACCOUNT_NUMBER
1516: INTO l_account_number
1517: FROM HZ_CUST_ACCOUNTS ACCT,
1518: HZ_CUST_ACCT_RELATE_ALL ACCT_REL
1519: WHERE ACCT.CUST_ACCOUNT_ID = l_param_value
1520: AND ACCT.CUST_ACCOUNT_ID = ACCT_REL.CUST_ACCOUNT_ID;
1521:

Line 1582: hz_cust_accounts b

1578: SELECT b.account_number
1579: INTO l_account_number
1580: FROM hz_cust_site_uses_all p,
1581: hz_cust_acct_sites_all a,
1582: hz_cust_accounts b
1583: WHERE p.site_use_id = l_param_value
1584: AND a.cust_acct_site_id = p.cust_acct_site_id
1585: AND a.cust_account_id = b.cust_account_id;
1586:

Line 1618: hz_cust_accounts b

1614: SELECT b.account_number
1615: INTO l_account_number
1616: FROM hz_cust_site_uses_all p,
1617: hz_cust_acct_sites_all a,
1618: hz_cust_accounts b
1619: WHERE p.site_use_id = l_param_value
1620: AND a.cust_acct_site_id = p.cust_acct_site_id
1621: AND a.cust_account_id = b.cust_account_id;
1622:

Line 1658: hz_cust_accounts acc

1654: INTO l_account_number,
1655: l_site_use_id
1656: FROM HZ_CUST_PROFILE_AMTS pfl_amnts,
1657: HZ_CUSTOMER_PROFILES pfl,
1658: hz_cust_accounts acc
1659: WHERE pfl_amnts.cust_account_id = acc.cust_account_id
1660: AND pfl.cust_account_profile_id = pfl_amnts.cust_account_profile_id
1661: AND pfl_amnts.CUST_ACCT_PROFILE_AMT_ID = l_param_value;
1662:

Line 1694: FROM hz_cust_accounts

1690: BEGIN
1691:
1692: SELECT account_number
1693: BULK COLLECT INTO l_acc_num
1694: FROM hz_cust_accounts
1695: WHERE party_id = l_param_value;
1696:
1697:
1698: EXCEPTION

Line 1738: hz_cust_accounts b

1734: a.site_use_id
1735: INTO l_account_number,
1736: l_site_use_id
1737: FROM hz_customer_profiles a,
1738: hz_cust_accounts b
1739: WHERE a.cust_account_profile_id = l_param_value
1740: AND a.cust_account_id = b.cust_account_id;
1741:
1742: XNB_DEBUG.log('oracle.apps.ar.hz.CustomerProfile',l_account_number);

Line 1802: hz_cust_accounts c

1798: SELECT c.account_number
1799: BULK COLLECT INTO l_acc_num
1800: FROM hz_contact_points a,
1801: hz_parties b,
1802: hz_cust_accounts c
1803: WHERE a.contact_point_id = l_param_value
1804: AND a.owner_table_id = b.party_id
1805: AND b.party_id = c.party_id;
1806: