DBA Data[Home] [Help]

APPS.OKE_MDS_RELIEF_PKG dependencies on OKE_K_DELIVERABLES_B

Line 35: , oke_k_deliverables_b d

31: , d.task_id
32: , d.unit_number
33: FROM mtl_system_items c
34: , mtl_material_transactions a
35: , oke_k_deliverables_b d
36: , mrp_schedule_dates m
37: WHERE a.source_code = 'OKE'
38: AND a.organization_id = c.organization_id
39: AND a.inventory_item_id = c.inventory_item_id

Line 125: , oke_k_deliverables_b d

121: , d.unit_number
122: , m.schedule_quantity
123: , m.schedule_date
124: FROM okc_k_lines_b a
125: , oke_k_deliverables_b d
126: , mrp_schedule_dates m
127: , okc_statuses_b sts
128: WHERE d.k_line_id = a.id
129: And m.mps_transaction_id = d.mps_transaction_id

Line 220: UPDATE oke_k_deliverables_b d

216: WHERE CURRENT OF qty_c;
217:
218: write_log( 'MDS entry updated' );
219:
220: UPDATE oke_k_deliverables_b d
221: SET PO_REF_3 = l_mds_tbl(i).mtl_transaction_id
222: WHERE mps_transaction_id = l_mds_tbl(i).mps_transaction_id;
223:
224: write_log( 'DLV entry updated' );