eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 368: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE := NULL;

364: l_replen_allocated_qty JMF_SHIKYU_REPLENISHMENTS.allocated_quantity%TYPE;
365: l_replen_allocable_qty JMF_SHIKYU_REPLENISHMENTS.allocable_quantity%TYPE;
366: l_allocated_uom JMF_SHIKYU_ALLOCATIONS.uom%TYPE;
367: l_allocation_qty JMF_SHIKYU_ALLOCATIONS.allocated_quantity%TYPE;
368: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE := NULL;
369: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
370: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
371: l_message VARCHAR(2000);
372: l_status_flag BOOLEAN;

Line 858: oe_order_lines_all oola

854: jsr.primary_uom,
855: oola.schedule_ship_date
856: FROM jmf_shikyu_replenishments jsr,
857: jmf_subcontract_orders jso,
858: oe_order_lines_all oola
859: WHERE jsr.oem_organization_id = jso.oem_organization_id
860: AND jsr.tp_organization_id = jso.tp_organization_id
861: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
862: AND jsr.shikyu_component_id = p_component_id

Line 1494: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;

1490: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1491: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1492: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1493: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1494: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
1495: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
1496: l_new_replen_qty NUMBER;
1497:
1498: g_process_replen_po_exc EXCEPTION;

Line 2682: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE

2678: , replenishment_so_line_id NUMBER
2679: , component_id NUMBER
2680: , qty NUMBER
2681: , qty_uom VARCHAR2(3)
2682: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2683: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2684: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2685: );
2686:

Line 2684: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE

2680: , qty NUMBER
2681: , qty_uom VARCHAR2(3)
2682: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2683: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2684: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2685: );
2686:
2687: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
2688:

Line 2714: OE_ORDER_LINES_ALL oola,

2710: , oola.schedule_ship_date
2711: , ooha.order_number
2712: , oola.line_number
2713: FROM JMF_SHIKYU_ALLOCATIONS jsa,
2714: OE_ORDER_LINES_ALL oola,
2715: OE_ORDER_HEADERS_ALL ooha
2716: WHERE jsa.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2717: AND jsa.shikyu_component_id = p_component_id
2718: AND oola.line_id = jsa.replenishment_so_line_id

Line 3172: oe_order_lines_all oola

3168: oola.ordered_quantity,
3169: jsr.primary_uom,
3170: oola.schedule_ship_date
3171: FROM jmf_shikyu_replenishments jsr,
3172: oe_order_lines_all oola
3173: WHERE jsr.replenishment_so_line_id = oola.line_id
3174: AND jsr.status <> 'CLOSED'
3175: AND jsr.status <> 'CANCELLED'
3176: AND oola.open_flag = 'N'

Line 3183: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

3179:
3180: l_closed_so_line_tbl g_replen_so_qty_tbl_type;
3181: l_closed_so_line_rec g_replen_so_qty_rec_type;
3182: l_tbl_index NUMBER;
3183: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
3184: l_ordered_primary_qty NUMBER;
3185:
3186: BEGIN
3187:

Line 3354: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;

3350: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
3351: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
3352: l_unallocated_primary_qty NUMBER;
3353: l_shipped_primary_qty NUMBER;
3354: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
3355: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
3356:
3357: l_tbl_index NUMBER;
3358: l_qty_to_reduce NUMBER;

Line 3355: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;

3351: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
3352: l_unallocated_primary_qty NUMBER;
3353: l_shipped_primary_qty NUMBER;
3354: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
3355: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
3356:
3357: l_tbl_index NUMBER;
3358: l_qty_to_reduce NUMBER;
3359: l_actual_reduced_qty NUMBER;

Line 3435: OE_ORDER_LINES_ALL oola

3431: l_allocated_primary_qty,
3432: l_shipped_primary_qty,
3433: l_ordered_uom
3434: FROM JMF_SHIKYU_REPLENISHMENTS jsr,
3435: OE_ORDER_LINES_ALL oola
3436: WHERE jsr.REPLENISHMENT_SO_LINE_ID = p_replen_order_line_id
3437: AND jsr.replenishment_so_line_id = oola.line_id;
3438:
3439: l_unallocated_primary_qty := l_allocable_primary_qty - l_allocated_primary_qty;

Line 3735: , OE_ORDER_LINES_ALL oel

3731: , jsr.ALLOCABLE_PRIMARY_UOM_QUANTITY allocable_primary_UOM_quantity
3732: , jsr.allocable_quantity allocable_quantity
3733: , jsr.allocated_quantity allocated_quantity
3734: FROM JMF_SHIKYU_REPLENISHMENTS jsr
3735: , OE_ORDER_LINES_ALL oel
3736: , OE_ORDER_HEADERS_ALL oeh
3737: , JMF_SHIKYU_ALLOCATIONS jsa
3738: WHERE oeh.header_id = jsr.REPLENISHMENT_SO_HEADER_ID
3739: AND oel.header_id = oeh.header_id

Line 3763: FROM oe_order_lines_all

3759: , schedule_ship_date
3760: , header_id
3761: , split_from_line_id
3762: , line_number
3763: FROM oe_order_lines_all
3764: WHERE header_id = l_header_id )
3765: CONNECT BY PRIOR line_id = split_from_line_id
3766: START WITH line_id = l_parent_so_line_id;
3767:

Line 3778: FROM oe_order_lines_all

3774: , ordered_quantity
3775: , schedule_ship_date
3776: , header_id
3777: , split_from_line_id
3778: FROM oe_order_lines_all
3779: WHERE header_id = l_header_id
3780: and split_from_line_id = l_parent_so_line_id ;
3781: */
3782: -- commented out for bug 5437721. The CONNECT BY should work

Line 4469: OE_ORDER_LINES_ALL oola

4465: x_uom,
4466: x_primary_uom,
4467: x_replen_so_line_exists
4468: FROM JMF_SHIKYU_REPLENISHMENTS jsr,
4469: OE_ORDER_LINES_ALL oola
4470: WHERE jsr.replenishment_so_line_id = p_replen_so_line_id
4471: AND jsr.replenishment_so_line_id = oola.line_id;
4472:
4473: EXCEPTION

Line 4554: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;

4550: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Replenishment';
4551:
4552: -- Information from Replenishment SO Line
4553:
4554: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4555: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
4556: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
4557: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;

Line 4555: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;

4551:
4552: -- Information from Replenishment SO Line
4553:
4554: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4555: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
4556: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
4557: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
4559:

Line 4556: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;

4552: -- Information from Replenishment SO Line
4553:
4554: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4555: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
4556: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
4557: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
4559:
4560: -- Information from Replenishment PO Shipment

Line 4557: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

4553:
4554: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4555: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
4556: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
4557: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
4559:
4560: -- Information from Replenishment PO Shipment
4561:

Line 4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;

4554: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4555: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
4556: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
4557: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
4558: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
4559:
4560: -- Information from Replenishment PO Shipment
4561:
4562: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;

Line 4616: FROM OE_ORDER_LINES_ALL oola

4612: l_ordered_qty,
4613: l_ordered_uom,
4614: l_schedule_ship_date,
4615: l_org_id
4616: FROM OE_ORDER_LINES_ALL oola
4617: WHERE oola.line_id = p_replen_so_line_id;
4618:
4619: IF (g_fnd_debug = 'Y' AND
4620: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)

Line 4847: FROM oe_order_lines_all oola,

4843: FROM jmf_shikyu_components jsc
4844: WHERE jsc.shikyu_component_id = p_component_id
4845: AND jsc.subcontract_po_shipment_id = p_subcontract_po_shipment_id
4846: AND EXISTS (SELECT 'x'
4847: FROM oe_order_lines_all oola,
4848: oe_order_headers_all ooha
4849: WHERE oola.line_id = p_replen_so_line_id
4850: AND oola.inventory_item_id = p_component_id
4851: AND oola.price_list_id = jsc.price_list_id

Line 4931: FROM oe_order_lines_all oola

4927: WHERE mtlp.organization_id = jso.tp_organization_id
4928: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
4929: AND ( (mtlp.project_control_level = 1
4930: AND EXISTS (SELECT 'x'
4931: FROM oe_order_lines_all oola
4932: WHERE oola.line_id = p_replen_so_line_id
4933: AND jso.project_id IS NOT NULL
4934: AND jso.project_id = oola.project_id
4935: AND NVL(jso.task_id, -1) = NVL(oola.task_id, -1)))

Line 4938: FROM oe_order_lines_all oola

4934: AND jso.project_id = oola.project_id
4935: AND NVL(jso.task_id, -1) = NVL(oola.task_id, -1)))
4936: OR (mtlp.project_control_level = 2
4937: AND EXISTS (SELECT 'x'
4938: FROM oe_order_lines_all oola
4939: WHERE oola.line_id = p_replen_so_line_id
4940: AND jso.project_id IS NOT NULL
4941: AND jso.task_id IS NOT NULL
4942: AND jso.project_id = oola.project_id

Line 4947: FROM oe_order_lines_all oola

4943: AND jso.task_id = oola.task_id))
4944: OR (jso.project_id IS NULL
4945: AND jso.task_id IS NULL
4946: AND EXISTS (SELECT 'x'
4947: FROM oe_order_lines_all oola
4948: WHERE oola.line_id = p_replen_so_line_id
4949: AND oola.project_id IS NULL
4950: AND oola.task_id IS NULL))
4951: );