[Home] [Help]
119: --| to get the name of the TO and FROM |
120: --| Organization in the current session language. |
121: --| 08-DEC-2006 amy bug fix for 5702139: Updated procedure |
122: --| get_unallocated_rep_po to pass correct uom |
123: --| jmf_shikyu_allocations.uom to parameter p_current_uom_code |
124: --| when call function get_item_primary_quantity |
125: --| to convert allocated quantity |
126: --| 11-DEC-2006 amy bug fix for 5702139: Updated procedure |
127: --| get_unallocated_rep_po again to pass primary |
1304: --Updated to fix bug 5509464 start
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
1373: --Updated to fix bug 5509464 start
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
1881: FROM jmf_shikyu_cfr_mid_temp mid_s
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
2141: ,jsa_a.uom
2142: ,NVL(jsa_a.allocated_quantity
2143: ,0)))
2144: ,0)
2145: FROM jmf_shikyu_allocations jsa_a
2146: WHERE jsa_a.subcontract_po_shipment_id =
2147: comp.subcontract_po_shipment_id
2148: AND jsa_a.shikyu_component_id = comp.shikyu_component_id) -
2149: wip_req.quantity_issued
2333: ,jsr.tp_supplier_site_id
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
2492: ,0))
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
2579: SELECT cfr_mid.shikyu_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
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
3300: ,po_headers_all pha_s
3301: ,po_lines_all pla_s
3302: ,po_releases_all pra_s
3748: ,cfr_mid_temp.primary_uom
3749: from jmf_shikyu_cfr_mid_temp cfr_mid_temp
3750: where cfr_mid_temp.row_type = CFR_TMP_RCV_ROW) cfr_mid_item_group
3751: ,jmf_shikyu_replenishments jsr
3752: ,jmf_shikyu_allocations jsa
3753: ,oe_order_lines_all oola
3754: ,oe_order_headers_all ooha
3755: ,po_line_locations_all plla_s
3756: ,po_headers_all pha_s