DBA Data[Home] [Help]

APPS.INV_TRANSACTION_FLOW_PUB dependencies on HZ_PARTIES

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

4498: l_from_ou_name VARCHAR2(240);
4499: l_to_ou_name VARCHAR2(240);
4500: l_location VARCHAR2(40);
4501: l_customer_number VARCHAR2(30);
4502: --For bug6460311.column length in table hz_parties is varchar2(360)
4503: --l_customer_name VARCHAR2(50);
4504: l_customer_name VARCHAR2(360);
4505: l_cto_item_flag VARCHAR2(1);
4506: l_trx_src_type_id NUMBER := NULL;

Line 4743: FROM hz_parties party, hz_cust_accounts cust_acct

4739: , (SELECT cust_account_id customer_id
4740: , party.party_name customer_name
4741: , party.party_number customer_number
4742: , price_list_id
4743: FROM hz_parties party, hz_cust_accounts cust_acct
4744: WHERE cust_acct.party_id = party.party_id) rc
4745: WHERE mip.sell_organization_id = p_to_org_id
4746: AND mip.ship_organization_id = p_from_org_id
4747: AND mip.flow_type = l_flow_type