DBA Data[Home] [Help]

APPS.RLM_FORECAST_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 450: rlm_interface_lines_all ril

446: ril.inventory_item_id,
447: ril.industry_attribute15,
448: ril.ship_to_customer_id
449: FROM rlm_interface_headers rih,
450: rlm_interface_lines_all ril
451: WHERE rih.header_id = x_Sched_rec.header_id
452: AND ril.header_id = rih.header_id
453: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id
454: AND ril.item_detail_type = k_MRP_FORECAST

Line 666: FROM rlm_interface_lines_all

662: x_progress VARCHAR2(3) := '010';
663:
664: CURSOR c IS
665: SELECT *
666: FROM rlm_interface_lines_all
667: WHERE header_id = x_header_id
668: AND ship_from_org_id = x_Group_rec.ship_from_org_id
669: AND ship_to_site_use_id = x_Group_rec.ship_to_site_use_id
670: AND bill_to_site_use_id = x_Group_rec.bill_to_site_use_id