DBA Data[Home] [Help]

APPS.MRP_CREATE_SCHEDULE_ISO dependencies on OE_INVOICE_TO_ORGS_V

Line 132: from oe_invoice_to_orgs_v org, hz_parties hp, hz_cust_accounts hca

128:
129:
130: CURSOR c_bill_to_location_id(p_customer_id number) IS
131: select org.organization_id
132: from oe_invoice_to_orgs_v org, hz_parties hp, hz_cust_accounts hca
133: where org.customer_id=hca.cust_account_id
134: and hp.party_id = hca.party_id
135: and hca.cust_account_id = p_customer_id
136: and rownum < 2;