APPS.RLM_MANAGE_DEMAND_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 644: FROM rlm_interface_lines_all

640: IS
641: --
642: CURSOR c_Demand IS
643: SELECT *
644: FROM rlm_interface_lines_all
645: WHERE header_id = x_Sched_rec.header_id
646: AND ship_from_org_id = x_Group_rec.ship_from_org_id
647: AND ship_to_address_id = x_Group_rec.ship_to_address_id
648: AND customer_item_id = x_Group_rec.customer_item_id

Line 657: FROM rlm_interface_lines_all

653: ORDER BY START_DATE_TIME;
654:
655: CURSOR c_DemandCum IS
656: SELECT *
657: FROM rlm_interface_lines_all
658: WHERE header_id = x_Sched_rec.header_id
659: AND ship_from_org_id = x_Group_rec.ship_from_org_id
660: AND ship_to_address_id = x_Group_rec.ship_to_address_id
661: AND customer_item_id = x_Group_rec.customer_item_id

Line 4241: INSERT INTO rlm_interface_lines_all(

4237: IF x_ManageDemand_rec.org_id IS NULL THEN
4238: RAISE e_NullOrgId;
4239: END IF;
4240: --
4241: INSERT INTO rlm_interface_lines_all(
4242: line_id,
4243: header_id,
4244: schedule_item_num,
4245: agreement_id,

Line 4870: UPDATE rlm_interface_lines_all

4866: rlm_core_sv.dlog(C_DEBUG,'x_ManageDemand_rec.blanket_number',
4867: x_ManageDemand_rec.blanket_number);
4868: END IF;
4869: --
4870: UPDATE rlm_interface_lines_all
4871: SET primary_quantity = x_ManageDemand_rec.primary_quantity,
4872: ship_from_org_id = x_ManageDemand_rec.ship_from_org_id,
4873: item_detail_type = x_ManageDemand_rec.item_detail_type,
4874: item_detail_subtype = x_ManageDemand_rec.item_detail_subtype,

Line 6114: rlm_interface_lines_all ril

6110: ril.ship_to_customer_id
6111: -- Perf change
6112: -- ril.cust_production_seq_num
6113: FROM rlm_interface_headers rih,
6114: rlm_interface_lines_all ril
6115: WHERE rih.header_id = x_Sched_rec.header_id
6116: AND rih.org_id = ril.org_id
6117: AND ril.header_id = rih.header_id
6118: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 6458: FROM rlm_interface_lines_all

6454: x_progress VARCHAR2(3) := '010';
6455: --
6456: CURSOR c IS
6457: SELECT *
6458: FROM rlm_interface_lines_all
6459: WHERE header_id = x_HeaderId
6460: --and inventory_item_id = x_GroupRec.inventory_item_id
6461: and customer_item_id = x_GroupRec.customer_item_id
6462: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6473: FROM rlm_interface_lines_all

6469: FOR UPDATE NOWAIT;
6470: --
6471: CURSOR c_blanket IS
6472: SELECT *
6473: FROM rlm_interface_lines_all
6474: WHERE header_id = x_HeaderId
6475: and customer_item_id = x_GroupRec.customer_item_id
6476: and ship_from_org_id = x_GroupRec.ship_from_org_id
6477: and ship_to_org_id = x_GroupRec.ship_to_org_id