[Home] [Help]
1022: FROM jmf_shikyu_cfr_mid_temp mid
1023: ,po_line_locations_all pll
1024: ,rcv_transactions rt
1025: --Added to fix bug 5509464 start
1026: ,po_headers_all pha
1027: --Added to fix bug 5509464 end
1028: WHERE mid.row_type = p_rep_po_unalloc_row_type
1029: AND NVL(mid.get_rcv_flag
1030: ,'N') <> CFR_REP_PO_GET_RCV_FLAG --if the rep_po line have done get rcv process, the get_rcv_flag will be set to 1
1038:
1039: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1040: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1041: --Added to fix bug 5509464 start
1042: l_supplier_id po_headers_all.vendor_id%TYPE; --for cursor
1043: l_supplier_site_id po_headers_all.vendor_site_id%TYPE; --for cursor
1044: --Added to fix bug 5509464 end
1045:
1046: l_rep_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1039: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE; --for cursor
1040: l_rcv_unprocessed_primary_qty rcv_transactions.primary_quantity%TYPE; --for cursor
1041: --Added to fix bug 5509464 start
1042: l_supplier_id po_headers_all.vendor_id%TYPE; --for cursor
1043: l_supplier_site_id po_headers_all.vendor_site_id%TYPE; --for cursor
1044: --Added to fix bug 5509464 end
1045:
1046: l_rep_po_residual_pri rcv_transactions.primary_quantity%TYPE;
1047: l_rcv_unallocated_pri rcv_transactions.primary_quantity%TYPE;
1325: ,pha.vendor_site_id --p_supplier_site_id
1326: ,p_oem_inv_org_id
1327: ,p_tp_inv_org_id
1328: ,p_item_id
1329: FROM po_headers_all pha
1330: ,po_lines_all pla
1331: ,po_line_locations_all plla
1332: ,MTL_UNITS_OF_MEASURE_TL uom_tl
1333: ,HR_ORGANIZATION_INFORMATION hoi -- Add this table to get information of oem
2154: ,sub_po.tp_organization_id
2155: ,comp.shikyu_component_id
2156: FROM po_line_locations_all pll
2157: ,jmf_subcontract_orders sub_po
2158: ,po_headers_all ph
2159: ,jmf_shikyu_components comp
2160: ,wip_requirement_operations wip_req
2161: WHERE pll.line_location_id = sub_po.subcontract_po_shipment_id
2162: AND pll.quantity > pll.quantity_received --this can be ignore if allow the allocated qty larger than ordered qty
3284: ,mtl_parameters mp_oem
3285: ,mtl_parameters mp_tp
3286: ,po_vendors pv
3287: ,po_vendor_sites_all pvs
3288: ,po_headers_all ph
3289: ,po_vendor_contacts pvc
3290: ,mtl_system_items_vl item_v
3291: ,po_lines_all pl
3292: ,pa_projects_all prj
3296: ,oe_order_lines_all oola
3297: ,oe_order_headers_all ooha
3298: ,jmf_shikyu_allocations jsa
3299: ,po_line_locations_all plla_s
3300: ,po_headers_all pha_s
3301: ,po_lines_all pla_s
3302: ,po_releases_all pra_s
3303: ,cst_item_costs cic
3304: WHERE cfr_mid.row_type = CFR_TMP_RCV_ROW
3755: ,jmf_shikyu_allocations jsa
3756: ,oe_order_lines_all oola
3757: ,oe_order_headers_all ooha
3758: ,po_line_locations_all plla_s
3759: ,po_headers_all pha_s
3760: ,po_lines_all pla_s
3761: ,po_releases_all pra_s
3762: ,wip_requirement_operations wro
3763: ,MTL_SYSTEM_ITEMS_B_KFV msibk
3919: ,oe_order_headers_all ooha
3920: ,po_line_locations_all plla
3921: ,po_lines_all pla
3922: ,po_releases_all pra
3923: ,po_headers_all pha
3924: ,jmf_shikyu_replenishments jsr
3925: ,hr_organization_information hoi
3926: -- Amy added to fix bug 5583680 start
3927: ,hr_all_organization_units_tl oem_haoutl
4091: ,oe_order_headers_all ooha
4092: ,po_line_locations_all plla
4093: ,po_lines_all pla
4094: ,po_releases_all pra
4095: ,po_headers_all pha
4096: ,jmf_shikyu_replenishments jsr
4097: ,hr_organization_information hoi
4098: WHERE oola.header_id = ooha.header_id
4099: AND plla.po_line_id = pla.po_line_id