APPS.RLM_RD_SV dependencies on RLM_SCHEDULE_LINES

Line 3966: rlm_schedule_lines_all sl

3962: --
3963: SELECT COUNT(*)
3964: INTO v_cumDiscrete
3965: FROM rlm_interface_lines il,
3966: rlm_schedule_lines_all sl
3967: WHERE il.header_id = x_Sched_rec.header_id
3968: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
3969: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
3970: AND il.inventory_item_id = x_Group_rec.inventory_item_id

Line 10250: rlm_schedule_lines_all sl

10246: --
10247: SELECT COUNT(*)
10248: INTO v_ActualCount
10249: FROM rlm_interface_lines il,
10250: rlm_schedule_lines_all sl
10251: WHERE il.header_id = x_Sched_rec.header_id
10252: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
10253: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
10254: AND il.inventory_item_id = x_Group_rec.inventory_item_id

Line 12025: UPDATE rlm_schedule_lines

12021: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
12022: rlm_core_sv.k_PS_FROZEN_FIRM)
12023: AND item_detail_type IN (k_PAST_DUE_FIRM, k_FIRM, k_FORECAST, k_RECT);
12024: --
12025: UPDATE rlm_schedule_lines
12026: SET process_status = x_Status
12027: WHERE header_id = x_ScheduleHeaderid
12028: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
12029: rlm_core_sv.k_PS_FROZEN_FIRM)

Line 12056: UPDATE rlm_schedule_lines

12052: IF (l_debug <> -1) THEN
12053: rlm_core_sv.dlog(k_DEBUG,'No of interface Lines Updated ', SQL%ROWCOUNT);
12054: END IF;
12055: --
12056: UPDATE rlm_schedule_lines
12057: SET process_status = x_Status
12058: WHERE header_id = x_ScheduleheaderId
12059: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12060: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 13662: FROM rlm_schedule_lines

13658: primary_quantity,
13659: -- do not use item_ref_value_1
13660: substr(item_detail_ref_value_1,1,29) shipper_Id,
13661: line_id
13662: FROM rlm_schedule_lines
13663: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
13664: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13665: AND inventory_item_id = x_Group_rec.inventory_item_id
13666: AND customer_item_id = x_Group_rec.customer_item_id

Line 13678: FROM rlm_schedule_lines

13674: primary_quantity,
13675: -- do not use item_ref_value_1
13676: substr(item_detail_ref_value_1,1,29) shipper_Id,
13677: line_id
13678: FROM rlm_schedule_lines
13679: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
13680: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13681: AND inventory_item_id = x_Group_rec.inventory_item_id
13682: AND customer_item_id = x_Group_rec.customer_item_id

Line 14977: OPEN c_flex_ind_attr(v_ColumnName, 'RLM_SCHEDULE_LINES', 'Y', 662);

14973: v_ColumnName := SUBSTR(v_lookupCode, 1, INSTR(v_lookupCode, ',')-1);
14974: --
14975: IF (INSTR(v_ColumnName, 'INDUSTRY_ATTRIBUTE') = 1) THEN
14976: --
14977: OPEN c_flex_ind_attr(v_ColumnName, 'RLM_SCHEDULE_LINES', 'Y', 662);
14978: FETCH c_flex_ind_attr INTO v_lookupMeaning;
14979: CLOSE c_flex_ind_attr;
14980: --
14981: ELSIF(INSTR(v_ColumnName, 'ATTRIBUTE') = 1) THEN