DBA Data[Home] [Help]

APPS.JMF_SUBCONTRACT_ORDERS_PVT dependencies on PO_RELEASES_ALL

Line 172: --| 06/14/2006 vchu Added a join to po_releases_all table |

168: --| (in Load_Subcontract_Orders) to take |
169: --| the unit_meas_lookup_code from the PO |
170: --| Line if that of the PO Line Location |
171: --| was NULL. |
172: --| 06/14/2006 vchu Added a join to po_releases_all table |
173: --| in the select statement for inserting |
174: --| into the JMF_SUBCONTRACT_ORDERS_TEMP |
175: --| temp table, in order to make sure the |
176: --| Blanket Releases are approved, if the |

Line 1363: , po_releases_all por

1359: po_line_locations_all poll
1360: , po_headers_all poh
1361: , po_lines_all pol
1362: , mtl_units_of_measure muom
1363: , po_releases_all por
1364: WHERE poll.po_header_id = poh.po_header_id
1365: AND poll.po_line_id = pol.po_line_id
1366: AND poh.po_header_id = pol.po_header_id
1367: AND poll.po_release_id = por.po_release_id (+)