APPS.RLM_MESSAGE_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 454: rlm_interface_lines_all lines

450: --
451: CURSOR c_GetShipTo IS
452: SELECT ece_tp_location_code
453: FROM hz_cust_acct_sites_all acct_site,
454: rlm_interface_lines_all lines
455: WHERE lines.ship_to_address_id = acct_site.cust_acct_site_id
456: AND lines.line_id = x_InterfaceLineId;
457: --
458: CURSOR c_GetBillTo IS

Line 461: rlm_interface_lines_all lines

457: --
458: CURSOR c_GetBillTo IS
459: SELECT ece_tp_location_code
460: FROM hz_cust_acct_sites_all acct_site,
461: rlm_interface_lines_all lines
462: WHERE lines.bill_to_address_id = acct_site.cust_acct_site_id
463: AND lines.line_id = x_InterfaceLineId;
464: --
465: CURSOR c_GetIntrmdShipTo IS

Line 468: rlm_interface_lines_all lines

464: --
465: CURSOR c_GetIntrmdShipTo IS
466: SELECT ece_tp_location_code
467: FROM hz_cust_acct_sites_all acct_site,
468: rlm_interface_lines_all lines
469: WHERE lines.intrmd_ship_to_id = acct_site.cust_acct_site_id
470: AND lines.line_id = x_InterfaceLineId;
471: --
472: -- Following cursor is changed as per TCA obsolescence project.

Line 511: rlm_interface_lines_all ril,

507: ril.CUST_PRODUCTION_LINE ,
508: ril.CUSTOMER_DOCK_CODE ,
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

Line 612: rlm_interface_lines_all ril,

608: NULL, --ril.CUST_PRODUCTION_LINE ,
609: NULL, --ril.CUSTOMER_DOCK_CODE ,
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