DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on PO_LINES_ALL

Line 55: --| PO_LINES_ALL record. |

51: --| procedure to validate the project and task |
52: --| reference of a Replenishment Sales Order Line |
53: --| against the JMF_SUBCONTRACT_ORDERS record for |
54: --| the Subcontracting Order instead of the |
55: --| PO_LINES_ALL record. |
56: --| 03-AUG-2005 vchu Added the Initialize procedure to perform API |
57: --| Intialization. |
58: --| 04-AUG-2005 vchu Modified the Get_Available_Replenishment_So |
59: --| procedure: added a where clause condition to |

Line 1276: po_lines_all pla,

1272: plla.shipment_num
1273: FROM jmf_subcontract_orders jso,
1274: hr_organization_information hoi,
1275: po_line_locations_all plla,
1276: po_lines_all pla,
1277: po_headers_all pha,
1278: mtl_units_of_measure_vl muomv
1279: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1280: AND hoi.organization_id = jso.oem_organization_id

Line 3494: , po_line_num PO_LINES_ALL.LINE_NUM%TYPE

3490: , qty NUMBER
3491: , qty_uom VARCHAR2(3)
3492: , po_shipment_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE
3493: , po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE
3494: , po_line_num PO_LINES_ALL.LINE_NUM%TYPE
3495: , po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE
3496: );
3497:
3498: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;

Line 3535: PO_LINES_ALL pla,

3531: pla.line_num,
3532: plla.shipment_num
3533: FROM JMF_SHIKYU_ALLOCATIONS jsa,
3534: PO_LINE_LOCATIONS_ALL plla,
3535: PO_LINES_ALL pla,
3536: PO_HEADERS_ALL pha
3537: WHERE jsa.replenishment_so_line_id = p_replen_order_line_id
3538: AND jsa.shikyu_component_id = l_component_id
3539: AND jsa.subcontract_po_shipment_id = plla.line_location_id