DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on WIP_LPN_COMPLETIONS_LOTS

Line 1561: WIP_LPN_COMPLETIONS_LOTS WLCL,

1557: WLCL.lot_expiration_date,
1558: null,
1559: p_lpn_id
1560: FROM MTL_SYSTEM_ITEMS MSI,
1561: WIP_LPN_COMPLETIONS_LOTS WLCL,
1562: WIP_LPN_COMPLETIONS WLC
1563: WHERE wlc.header_id = cp_header_id
1564: AND wlc.transaction_source_type_id = 5 /* Job or Schedule */
1565: AND wlcl.header_id (+) = wlc.header_id