DBA Data[Home] [Help]

APPS.RLM_MESSAGE_SV dependencies on HZ_CUST_ACCOUNTS

Line 513: HZ_CUST_ACCOUNTS CUST_ACCT,

509: ril.SCHEDULE_LINE_ID
510: FROM rlm_interface_headers rih,
511: rlm_interface_lines_all ril,
512: HZ_PARTIES PARTY,
513: HZ_CUST_ACCOUNTS CUST_ACCT,
514: mtl_customer_items mtl
515: WHERE rih.ORG_ID = ril.ORG_ID
516: AND rih.header_id = x_InterfaceHeaderId
517: AND ril.line_id = x_InterfaceLineId

Line 565: HZ_CUST_ACCOUNTS CUST_ACCT

561: NULL,--ril.CUSTOMER_DOCK_CODE ,
562: NULL --ril.SCHEDULE_LINE_ID
563: FROM rlm_interface_headers rih,
564: HZ_PARTIES PARTY,
565: HZ_CUST_ACCOUNTS CUST_ACCT
566: WHERE rih.header_id = x_InterfaceHeaderId
567: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID (+)
568: AND rih.customer_id = cust_acct.cust_account_id (+);
569: --

Line 614: HZ_CUST_ACCOUNTS CUST_ACCT,

610: NULL --ril.SCHEDULE_LINE_ID
611: FROM rlm_interface_headers rih,
612: rlm_interface_lines_all ril,
613: HZ_PARTIES PARTY,
614: HZ_CUST_ACCOUNTS CUST_ACCT,
615: mtl_customer_items mtl
616: WHERE rih.ORG_ID = ril.ORG_ID
617: AND rih.header_id = x_InterfaceHeaderId
618: AND ril.line_id = x_InterfaceLineId