[Home] [Help]
1305: --,jsa.allocated_quantity)) pll_allocated
1306: ,nvl(jsa.allocated_quantity,0))) pll_allocated
1307: --Updated to fix bug 5509464 end
1308: FROM jmf_shikyu_allocations jsa
1309: ,jmf_shikyu_replenishments jsr
1310: ,MTL_UNITS_OF_MEASURE_TL uom_tl_s
1311: --Updated to fix bug 5509464 start
1312: --WHERE jsa.replenishment_so_line_id = jsr.replenishment_so_line_id
1313: -- AND jsa.shikyu_component_id = jsr.shikyu_component_id
1374: --,jsa.allocated_quantity)) pll_allocated
1375: ,nvl(jsa.allocated_quantity,0))) pll_allocated
1376: --Updated to fix bug 5509464 end
1377: FROM jmf_shikyu_allocations jsa
1378: ,jmf_shikyu_replenishments jsr
1379: ,MTL_UNITS_OF_MEASURE_TL uom_tl_s
1380: --Updated to fix bug 5509464 start
1381: --WHERE jsa.replenishment_so_line_id = jsr.replenishment_so_line_id
1382: -- AND jsa.shikyu_component_id = jsr.shikyu_component_id
1882: WHERE mid_s.row_type = p_rcv_transaction_row_type
1883: AND mid_s.shikyu_id = rt.transaction_id)
1884: ,0)
1885: FROM jmf_shikyu_allocations alloc
1886: ,jmf_shikyu_replenishments jsr
1887: ,jmf_shikyu_cfr_mid_temp mid
1888: ,rcv_transactions rt
1889: WHERE mid.row_type = p_sub_po_unconsumed_row_type
1890: AND NVL(mid.get_rep_flag
2334: ,jsr.oem_organization_id
2335: ,jsr.tp_organization_id
2336: ,alloc.shikyu_component_id
2337: FROM jmf_shikyu_allocations alloc
2338: ,jmf_shikyu_replenishments jsr
2339: ,jmf_shikyu_cfr_mid_temp mid
2340: ,jmf_subcontract_orders jso
2341: ,wip_requirement_operations wro
2342: WHERE mid.row_type = p_sub_po_unconsumed_row_type
2493: INTO l_sub_po_residual_pri
2494: FROM jmf_shikyu_cfr_mid_temp cfr_mid
2495: ,rcv_transactions rcv
2496: ,jmf_shikyu_allocations alloc
2497: ,jmf_shikyu_replenishments jsr
2498: WHERE rcv.transaction_id = P_rcv_transaction_id
2499: AND rcv.transaction_type = 'RECEIVE'
2500: AND cfr_mid.row_type = p_sub_po_unconsumed_row_type
2501: AND cfr_mid.supplier_id = p_supplier_id
2580: ,cfr_mid.primary_unconsumed_quantity
2581: FROM jmf_shikyu_cfr_mid_temp cfr_mid
2582: ,rcv_transactions rcv
2583: ,jmf_shikyu_allocations alloc
2584: ,jmf_shikyu_replenishments jsr
2585: WHERE rcv.transaction_id = p_rcv_transaction_id
2586: AND rcv.transaction_type = 'RECEIVE'
2587: AND cfr_mid.row_type = p_sub_po_unconsumed_row_type
2588: AND cfr_mid.supplier_id = p_supplier_id
3291: ,po_lines_all pl
3292: ,pa_projects_all prj
3293: ,pa_tasks task
3294: ,po_releases_all pra
3295: ,jmf_shikyu_replenishments jsr
3296: ,oe_order_lines_all oola
3297: ,oe_order_headers_all ooha
3298: ,jmf_shikyu_allocations jsa
3299: ,po_line_locations_all plla_s
3750: ,cfr_mid_temp.uom
3751: ,cfr_mid_temp.primary_uom
3752: from jmf_shikyu_cfr_mid_temp cfr_mid_temp
3753: where cfr_mid_temp.row_type = CFR_TMP_RCV_ROW) cfr_mid_item_group
3754: ,jmf_shikyu_replenishments jsr
3755: ,jmf_shikyu_allocations jsa
3756: ,oe_order_lines_all oola
3757: ,oe_order_headers_all ooha
3758: ,po_line_locations_all plla_s
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
3928: ,hr_organization_information tp_hoi
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
4100: AND plla.po_header_id = pha.po_header_id