APPS.CSD_OM_INTERFACE_PVT dependencies on HZ_PARTIES

Line 308: hz_parties hp,

304: haou.name org_name
305: FROM RCV_TRANSACTIONS rcv,
306: OE_ORDER_LINES_ALL oel,
307: OE_ORDER_HEADERS_ALL oeh,
308: hz_parties hp,
309: hz_cust_accounts hca,
310: hr_all_organization_units haou
311: WHERE rcv.oe_order_line_id = oel.line_id
312: AND rcv.transaction_type = 'DELIVER'

Line 1105: and C.owner_table_name(+)='HZ_PARTIES'

1101: C.contact_point_type,C.primary_flag
1102: FROM hz_contact_points C,
1103: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
1104: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
1105: and C.owner_table_name(+)='HZ_PARTIES'
1106: and C.contact_point_type(+)='PHONE'
1107: and C.status(+)='A'
1108: and C.primary_flag(+)='Y'
1109: and acct_role.party_id=C.owner_table_id(+) ;