APPS.RLM_RD_SV dependencies on RLM_SCHEDULE_LINES

Line 3801: rlm_schedule_lines_all sl

3797: --
3798: SELECT COUNT(*)
3799: INTO v_cumDiscrete
3800: FROM rlm_interface_lines il,
3801: rlm_schedule_lines_all sl
3802: WHERE il.header_id = x_Sched_rec.header_id
3803: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
3804: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
3805: AND il.inventory_item_id = x_Group_rec.inventory_item_id

Line 10076: rlm_schedule_lines_all sl

10072: --
10073: SELECT COUNT(*)
10074: INTO v_ActualCount
10075: FROM rlm_interface_lines il,
10076: rlm_schedule_lines_all sl
10077: WHERE il.header_id = x_Sched_rec.header_id
10078: AND il.ship_from_org_id = x_Group_rec.ship_from_org_id
10079: AND il.ship_to_org_id = x_Group_rec.ship_to_org_id
10080: AND il.inventory_item_id = x_Group_rec.inventory_item_id

Line 11831: UPDATE rlm_schedule_lines

11827: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
11828: rlm_core_sv.k_PS_FROZEN_FIRM)
11829: AND item_detail_type IN (k_PAST_DUE_FIRM, k_FIRM, k_FORECAST, k_RECT);
11830: --
11831: UPDATE rlm_schedule_lines
11832: SET process_status = x_Status
11833: WHERE header_id = x_ScheduleHeaderid
11834: AND process_status IN (rlm_core_sv.k_PS_AVAILABLE,
11835: rlm_core_sv.k_PS_FROZEN_FIRM)

Line 11862: UPDATE rlm_schedule_lines

11858: IF (l_debug <> -1) THEN
11859: rlm_core_sv.dlog(k_DEBUG,'No of interface Lines Updated ', SQL%ROWCOUNT);
11860: END IF;
11861: --
11862: UPDATE rlm_schedule_lines
11863: SET process_status = x_Status
11864: WHERE header_id = x_ScheduleheaderId
11865: AND ship_from_org_id = x_Group_rec.ship_from_org_id
11866: AND ship_to_org_id = x_Group_rec.ship_to_org_id

Line 13468: FROM rlm_schedule_lines

13464: primary_quantity,
13465: -- do not use item_ref_value_1
13466: substr(item_detail_ref_value_1,1,29) shipper_Id,
13467: line_id
13468: FROM rlm_schedule_lines
13469: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
13470: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13471: AND inventory_item_id = x_Group_rec.inventory_item_id
13472: AND customer_item_id = x_Group_rec.customer_item_id

Line 13484: FROM rlm_schedule_lines

13480: primary_quantity,
13481: -- do not use item_ref_value_1
13482: substr(item_detail_ref_value_1,1,29) shipper_Id,
13483: line_id
13484: FROM rlm_schedule_lines
13485: WHERE ship_from_org_id = x_Group_rec.ship_from_org_id
13486: AND ship_to_org_id = x_Group_rec.ship_to_org_id
13487: AND inventory_item_id = x_Group_rec.inventory_item_id
13488: AND customer_item_id = x_Group_rec.customer_item_id

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

14779: v_ColumnName := SUBSTR(v_lookupCode, 1, INSTR(v_lookupCode, ',')-1);
14780: --
14781: IF (INSTR(v_ColumnName, 'INDUSTRY_ATTRIBUTE') = 1) THEN
14782: --
14783: OPEN c_flex_ind_attr(v_ColumnName, 'RLM_SCHEDULE_LINES', 'Y', 662);
14784: FETCH c_flex_ind_attr INTO v_lookupMeaning;
14785: CLOSE c_flex_ind_attr;
14786: --
14787: ELSIF(INSTR(v_ColumnName, 'ATTRIBUTE') = 1) THEN