[Home] [Help]
3387: --ril.order_header_id,
3388: --ril.blanket_number
3389: --ril.cust_production_seq_num
3390: FROM rlm_interface_headers rih,
3391: rlm_interface_lines_all ril
3392: WHERE rih.header_id = x_Sched_rec.header_id
3393: AND rih.org_id = ril.org_id
3394: AND ril.header_id = rih.header_id
3395: AND ril.industry_attribute15 = x_Group_rec.ship_from_org_id
7429: firm demand is never replaced by forecast data */
7430: --
7431: OPEN c_NewReq_ref FOR
7432: SELECT line_id, primary_quantity
7433: FROM rlm_interface_lines_all -- Bug 5223933
7434: WHERE header_id = x_Sched_rec.header_id
7435: --global_atp
7436: AND ship_from_org_id = x_Group_rec.ship_from_org_id
7437: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12085: x_progress VARCHAR2(3) := '010';
12086:
12087: CURSOR c IS
12088: SELECT *
12089: FROM rlm_interface_lines_all
12090: WHERE header_id = x_header_id
12091: AND ship_from_org_id = x_Group_rec.ship_from_org_id
12092: AND ship_to_org_id = x_Group_rec.ship_to_org_id
12093: AND customer_item_id = x_Group_rec.customer_item_id
13766: rso.effective_start_date,
13767: ril.intrmd_ship_to_id, --Bugfix 5911991
13768: ril.intmed_ship_to_org_id --Bugfix 5911991
13769: FROM rlm_interface_headers rih,
13770: rlm_interface_lines_all ril,
13771: rlm_blanket_rso rso
13772: WHERE rih.header_id = x_Sched_rec.header_id
13773: AND rih.org_id = ril.org_id
13774: AND ril.header_id = rih.header_id
15088: PROCEDURE NAME: AssignMatchAttribValues
15089:
15090: ===========================================================================*/
15091: -- Bug 4297984
15092: PROCEDURE AssignMatchAttribValues ( x_req_rec IN rlm_interface_lines_all%ROWTYPE,
15093: x_match_rec IN OUT NOCOPY RLM_RD_SV.t_generic_rec)
15094: IS
15095:
15096: BEGIN