DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1058: l_component mtl_system_items_b_kfv.concatenated_segments%TYPE;

1054: l_msg_data VARCHAR2(240);
1055: l_qty_allocated NUMBER;
1056: l_actual_reduced_qty NUMBER;
1057:
1058: l_component mtl_system_items_b_kfv.concatenated_segments%TYPE;
1059: l_po_num po_headers_all.segment1%TYPE;
1060: l_po_line_num po_lines_all.line_num%TYPE;
1061: l_shipment_num po_line_locations.SHIPMENT_NUM%TYPE;
1062: l_allocable_qty NUMBER;

Line 1281: ,mtl_system_items_b_kfv item_kfv

1277: ,l_component
1278: FROM po_headers_all ph
1279: ,po_lines_all pl
1280: ,po_line_locations_all pll
1281: ,mtl_system_items_b_kfv item_kfv
1282: ,jmf_shikyu_components jsc
1283: WHERE pl.po_line_id = pll.po_line_id
1284: AND ph.po_header_id = pll.po_header_id
1285: AND pll.ship_to_organization_id = item_kfv.organization_id