[Home] [Help]
3552: --ril.order_header_id,
3553: --ril.blanket_number
3554: --ril.cust_production_seq_num
3555: FROM rlm_interface_headers rih,
3556: rlm_interface_lines_all ril
3557: WHERE rih.header_id = x_Sched_rec.header_id
3558: AND rih.org_id = ril.org_id
3559: AND ril.header_id = rih.header_id
3560: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id
7594: firm demand is never replaced by forecast data */
7595: --
7596: OPEN c_NewReq_ref FOR
7597: SELECT line_id, primary_quantity
7598: FROM rlm_interface_lines_all -- Bug 5223933
7599: WHERE header_id = x_Sched_rec.header_id
7600: --global_atp
7601: AND ship_from_org_id = x_Group_rec.ship_from_org_id
7602: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12279: x_progress VARCHAR2(3) := '010';
12280:
12281: CURSOR c IS
12282: SELECT *
12283: FROM rlm_interface_lines_all
12284: WHERE header_id = x_header_id
12285: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12286: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12287: AND customer_item_id = x_Group_rec.customer_item_id
13960: rso.effective_start_date,
13961: ril.intrmd_ship_to_id, --Bugfix 5911991
13962: ril.intmed_ship_to_org_id --Bugfix 5911991
13963: FROM rlm_interface_headers rih,
13964: rlm_interface_lines_all ril,
13965: rlm_blanket_rso rso
13966: WHERE rih.header_id = x_Sched_rec.header_id
13967: AND rih.org_id = ril.org_id
13968: AND ril.header_id = rih.header_id
15282: PROCEDURE NAME: AssignMatchAttribValues
15283:
15284: ===========================================================================*/
15285: -- Bug 4297984
15286: PROCEDURE AssignMatchAttribValues ( x_req_rec IN rlm_interface_lines_all%ROWTYPE,
15287: x_match_rec IN OUT NOCOPY RLM_RD_SV.t_generic_rec)
15288: IS
15289:
15290: BEGIN