1889: UPDATE JMF_SUBCONTRACT_ORDERS
1890: SET quantity = SHIKYU_reconcile_rec.quantity
1891: , need_by_date = SHIKYU_reconcile_rec.pol_need_by_date
1892: , last_update_date = sysdate
1893: , last_updated_by = FND_GLOBAL.user_id
1894: , last_update_login = FND_GLOBAL.login_id
1895: WHERE SUBCONTRACT_PO_HEADER_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_HEADER_ID
1896: and SUBCONTRACT_PO_LINE_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_LINE_ID
1897: and SUBCONTRACT_PO_SHIPMENT_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID ;
1890: SET quantity = SHIKYU_reconcile_rec.quantity
1891: , need_by_date = SHIKYU_reconcile_rec.pol_need_by_date
1892: , last_update_date = sysdate
1893: , last_updated_by = FND_GLOBAL.user_id
1894: , last_update_login = FND_GLOBAL.login_id
1895: WHERE SUBCONTRACT_PO_HEADER_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_HEADER_ID
1896: and SUBCONTRACT_PO_LINE_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_LINE_ID
1897: and SUBCONTRACT_PO_SHIPMENT_ID = SHIKYU_reconcile_rec.SUBCONTRACT_PO_SHIPMENT_ID ;
1898: