APPS.RLM_MANAGE_DEMAND_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 638: FROM rlm_interface_lines_all

634: IS
635: --
636: CURSOR c_Demand IS
637: SELECT *
638: FROM rlm_interface_lines_all
639: WHERE header_id = x_Sched_rec.header_id
640: AND ship_from_org_id = x_Group_rec.ship_from_org_id
641: AND ship_to_address_id = x_Group_rec.ship_to_address_id
642: AND customer_item_id = x_Group_rec.customer_item_id

Line 651: FROM rlm_interface_lines_all

647: ORDER BY START_DATE_TIME;
648:
649: CURSOR c_DemandCum IS
650: SELECT *
651: FROM rlm_interface_lines_all
652: WHERE header_id = x_Sched_rec.header_id
653: AND ship_from_org_id = x_Group_rec.ship_from_org_id
654: AND ship_to_address_id = x_Group_rec.ship_to_address_id
655: AND customer_item_id = x_Group_rec.customer_item_id

Line 4150: INSERT INTO rlm_interface_lines_all(

4146: IF x_ManageDemand_rec.org_id IS NULL THEN
4147: RAISE e_NullOrgId;
4148: END IF;
4149: --
4150: INSERT INTO rlm_interface_lines_all(
4151: line_id,
4152: header_id,
4153: schedule_item_num,
4154: agreement_id,

Line 4779: UPDATE rlm_interface_lines_all

4775: rlm_core_sv.dlog(C_DEBUG,'x_ManageDemand_rec.blanket_number',
4776: x_ManageDemand_rec.blanket_number);
4777: END IF;
4778: --
4779: UPDATE rlm_interface_lines_all
4780: SET primary_quantity = x_ManageDemand_rec.primary_quantity,
4781: ship_from_org_id = x_ManageDemand_rec.ship_from_org_id,
4782: item_detail_type = x_ManageDemand_rec.item_detail_type,
4783: item_detail_subtype = x_ManageDemand_rec.item_detail_subtype,

Line 6023: rlm_interface_lines_all ril

6019: ril.ship_to_customer_id
6020: -- Perf change
6021: -- ril.cust_production_seq_num
6022: FROM rlm_interface_headers rih,
6023: rlm_interface_lines_all ril
6024: WHERE rih.header_id = x_Sched_rec.header_id
6025: AND rih.org_id = ril.org_id
6026: AND ril.header_id = rih.header_id
6027: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id

Line 6367: FROM rlm_interface_lines_all

6363: x_progress VARCHAR2(3) := '010';
6364: --
6365: CURSOR c IS
6366: SELECT *
6367: FROM rlm_interface_lines_all
6368: WHERE header_id = x_HeaderId
6369: --and inventory_item_id = x_GroupRec.inventory_item_id
6370: and customer_item_id = x_GroupRec.customer_item_id
6371: and ship_from_org_id = x_GroupRec.ship_from_org_id

Line 6382: FROM rlm_interface_lines_all

6378: FOR UPDATE NOWAIT;
6379: --
6380: CURSOR c_blanket IS
6381: SELECT *
6382: FROM rlm_interface_lines_all
6383: WHERE header_id = x_HeaderId
6384: and customer_item_id = x_GroupRec.customer_item_id
6385: and ship_from_org_id = x_GroupRec.ship_from_org_id
6386: and ship_to_org_id = x_GroupRec.ship_to_org_id