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.

[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on HZ_PARTIES

Line 4397: --For bug6460311.column length in table hz_parties is varchar2(360)

4393: l_from_ou_name VARCHAR2(240);
4394: l_to_ou_name VARCHAR2(240);
4395: l_location VARCHAR2(40);
4396: l_customer_number VARCHAR2(30);
4397: --For bug6460311.column length in table hz_parties is varchar2(360)
4398: --l_customer_name VARCHAR2(50);
4399: l_customer_name VARCHAR2(360);
4400: l_cto_item_flag VARCHAR2(1);
4401: l_trx_src_type_id NUMBER := NULL;

Line 4574: FROM hz_parties party, hz_cust_accounts cust_acct

4570: , (SELECT cust_account_id customer_id
4571: , party.party_name customer_name
4572: , party.party_number customer_number
4573: , price_list_id
4574: FROM hz_parties party, hz_cust_accounts cust_acct
4575: WHERE cust_acct.party_id = party.party_id) rc
4576: WHERE mip.sell_organization_id = p_to_org_id
4577: AND mip.ship_organization_id = p_from_org_id
4578: AND mip.flow_type = l_flow_type