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 1310: , po_releases_all por

1306: po_line_locations_all poll
1307: , po_headers_all poh
1308: , po_lines_all pol
1309: , mtl_units_of_measure muom
1310: , po_releases_all por
1311: WHERE poll.po_header_id = poh.po_header_id
1312: AND poll.po_line_id = pol.po_line_id
1313: AND poh.po_header_id = pol.po_header_id
1314: AND poll.po_release_id = por.po_release_id (+)