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 1272: po_lines_all pla,

1268: plla.shipment_num
1269: FROM jmf_subcontract_orders jso,
1270: hr_organization_information hoi,
1271: po_line_locations_all plla,
1272: po_lines_all pla,
1273: po_headers_all pha,
1274: mtl_units_of_measure_vl muomv
1275: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1276: AND hoi.organization_id = jso.oem_organization_id

Line 3340: , po_line_num PO_LINES_ALL.LINE_NUM%TYPE

3336: , qty NUMBER
3337: , qty_uom VARCHAR2(3)
3338: , po_shipment_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%TYPE
3339: , po_header_num PO_HEADERS_ALL.SEGMENT1%TYPE
3340: , po_line_num PO_LINES_ALL.LINE_NUM%TYPE
3341: , po_shipment_num PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM%TYPE
3342: );
3343:
3344: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;

Line 3381: PO_LINES_ALL pla,

3377: pla.line_num,
3378: plla.shipment_num
3379: FROM JMF_SHIKYU_ALLOCATIONS jsa,
3380: PO_LINE_LOCATIONS_ALL plla,
3381: PO_LINES_ALL pla,
3382: PO_HEADERS_ALL pha
3383: WHERE jsa.replenishment_so_line_id = p_replen_order_line_id
3384: AND jsa.shikyu_component_id = l_component_id
3385: AND jsa.subcontract_po_shipment_id = plla.line_location_id