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 860: oe_order_lines_all oola

856: --Bugfix 14246759: Adding actual_shipment_date
857: oola.actual_shipment_date
858: FROM jmf_shikyu_replenishments jsr,
859: jmf_subcontract_orders jso,
860: oe_order_lines_all oola
861: WHERE jsr.oem_organization_id = jso.oem_organization_id
862: AND jsr.tp_organization_id = jso.tp_organization_id
863: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
864: AND jsr.shikyu_component_id = p_component_id

Line 1500: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;

1496: l_component_price JMF_SHIKYU_COMPONENTS.shikyu_component_price%TYPE;
1497: l_primary_uom_price JMF_SHIKYU_COMPONENTS.primary_uom_price%TYPE;
1498: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1499: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1500: l_new_replen_so_line_id OE_ORDER_LINES_ALL.line_id%TYPE;
1501: l_new_replen_po_shipment_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
1502: l_new_replen_qty NUMBER;
1503:
1504: g_process_replen_po_exc EXCEPTION;

Line 2689: , rso_line_actual_ship_date OE_ORDER_LINES_ALL.ACTUAL_SHIPMENT_DATE%TYPE

2685: , component_id NUMBER
2686: , qty NUMBER
2687: , qty_uom VARCHAR2(3)
2688: --Bugfix 14246759: Adding actual_shipment_date
2689: , rso_line_actual_ship_date OE_ORDER_LINES_ALL.ACTUAL_SHIPMENT_DATE%TYPE
2690: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2691: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2692: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2693: );

Line 2690: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE

2686: , qty NUMBER
2687: , qty_uom VARCHAR2(3)
2688: --Bugfix 14246759: Adding actual_shipment_date
2689: , rso_line_actual_ship_date OE_ORDER_LINES_ALL.ACTUAL_SHIPMENT_DATE%TYPE
2690: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2691: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2692: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2693: );
2694:

Line 2692: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE

2688: --Bugfix 14246759: Adding actual_shipment_date
2689: , rso_line_actual_ship_date OE_ORDER_LINES_ALL.ACTUAL_SHIPMENT_DATE%TYPE
2690: , replen_so_line_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE
2691: , replen_so_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE
2692: , replen_so_line_number OE_ORDER_LINES_ALL.LINE_NUMBER%TYPE
2693: );
2694:
2695: TYPE l_allocation_detail_tbl_type IS TABLE OF l_allocation_detail_rec_type INDEX BY BINARY_INTEGER;
2696:

Line 2724: OE_ORDER_LINES_ALL oola,

2720: , oola.schedule_ship_date
2721: , ooha.order_number
2722: , oola.line_number
2723: FROM JMF_SHIKYU_ALLOCATIONS jsa,
2724: OE_ORDER_LINES_ALL oola,
2725: OE_ORDER_HEADERS_ALL ooha
2726: WHERE jsa.subcontract_po_shipment_id = p_subcontract_po_shipment_id
2727: AND jsa.shikyu_component_id = p_component_id
2728: AND oola.line_id = jsa.replenishment_so_line_id

Line 3194: oe_order_lines_all oola

3190: --Bugfix 14246759: Adding this because the record structure g_replen_so_qty_rec_type
3191: --has changed.
3192: oola.actual_shipment_date
3193: FROM jmf_shikyu_replenishments jsr,
3194: oe_order_lines_all oola
3195: WHERE jsr.replenishment_so_line_id = oola.line_id
3196: --Bugfix 14078692: Adding nvl.
3197: AND nvl(jsr.status, 'XXX') <> 'CLOSED'
3198: AND nvl(jsr.status,'XXX') <> 'CANCELLED'

Line 3225: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

3221:
3222: l_closed_so_line_tbl g_replen_so_qty_tbl_type;
3223: l_closed_so_line_rec g_replen_so_qty_rec_type;
3224: l_tbl_index NUMBER;
3225: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
3226: l_ordered_primary_qty NUMBER;
3227:
3228: BEGIN
3229:

Line 3508: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;

3504: l_allocable_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocable_primary_uom_quantity%TYPE;
3505: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
3506: l_unallocated_primary_qty NUMBER;
3507: l_shipped_primary_qty NUMBER;
3508: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
3509: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
3510:
3511: l_tbl_index NUMBER;
3512: l_qty_to_reduce NUMBER;

Line 3509: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;

3505: l_allocated_primary_qty JMF_SHIKYU_REPLENISHMENTS.allocated_primary_uom_quantity%TYPE;
3506: l_unallocated_primary_qty NUMBER;
3507: l_shipped_primary_qty NUMBER;
3508: l_shipped_qty OE_ORDER_LINES_ALL.shipped_quantity%TYPE;
3509: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
3510:
3511: l_tbl_index NUMBER;
3512: l_qty_to_reduce NUMBER;
3513: l_actual_reduced_qty NUMBER;

Line 3593: OE_ORDER_LINES_ALL oola

3589: l_allocated_primary_qty,
3590: l_shipped_primary_qty,
3591: l_ordered_uom
3592: FROM JMF_SHIKYU_REPLENISHMENTS jsr,
3593: OE_ORDER_LINES_ALL oola
3594: WHERE jsr.REPLENISHMENT_SO_LINE_ID = p_replen_order_line_id
3595: AND jsr.replenishment_so_line_id = oola.line_id;
3596:
3597: l_unallocated_primary_qty := l_allocable_primary_qty - l_allocated_primary_qty;

Line 4061: , OE_ORDER_LINES_ALL oel

4057: , jsr.ALLOCABLE_PRIMARY_UOM_QUANTITY allocable_primary_UOM_quantity
4058: , jsr.allocable_quantity allocable_quantity
4059: , jsr.allocated_quantity allocated_quantity
4060: FROM JMF_SHIKYU_REPLENISHMENTS jsr
4061: , OE_ORDER_LINES_ALL oel
4062: , OE_ORDER_HEADERS_ALL oeh
4063: , JMF_SHIKYU_ALLOCATIONS jsa
4064: WHERE oeh.header_id = jsr.REPLENISHMENT_SO_HEADER_ID
4065: AND oel.header_id = oeh.header_id

Line 4093: FROM oe_order_lines_all

4089: , schedule_ship_date
4090: , header_id
4091: , split_from_line_id
4092: , line_number
4093: FROM oe_order_lines_all
4094: WHERE header_id = l_header_id )
4095: CONNECT BY PRIOR line_id = split_from_line_id
4096: START WITH line_id = l_parent_so_line_id;
4097:

Line 4108: FROM oe_order_lines_all

4104: , ordered_quantity
4105: , schedule_ship_date
4106: , header_id
4107: , split_from_line_id
4108: FROM oe_order_lines_all
4109: WHERE header_id = l_header_id
4110: and split_from_line_id = l_parent_so_line_id ;
4111: */
4112: -- commented out for bug 5437721. The CONNECT BY should work

Line 4913: OE_ORDER_LINES_ALL oola

4909: x_uom,
4910: x_primary_uom,
4911: x_replen_so_line_exists
4912: FROM JMF_SHIKYU_REPLENISHMENTS jsr,
4913: OE_ORDER_LINES_ALL oola
4914: WHERE jsr.replenishment_so_line_id = p_replen_so_line_id
4915: AND jsr.replenishment_so_line_id = oola.line_id;
4916:
4917: EXCEPTION

Line 4998: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;

4994: l_api_name CONSTANT VARCHAR2(30) := 'Populate_Replenishment';
4995:
4996: -- Information from Replenishment SO Line
4997:
4998: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4999: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
5000: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
5001: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
5002: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;

Line 4999: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;

4995:
4996: -- Information from Replenishment SO Line
4997:
4998: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4999: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
5000: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
5001: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
5002: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
5003:

Line 5000: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;

4996: -- Information from Replenishment SO Line
4997:
4998: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4999: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
5000: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
5001: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
5002: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
5003:
5004: -- Information from Replenishment PO Shipment

Line 5001: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;

4997:
4998: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4999: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
5000: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
5001: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
5002: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
5003:
5004: -- Information from Replenishment PO Shipment
5005:

Line 5002: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;

4998: l_replen_so_header_id OE_ORDER_LINES_ALL.header_id%TYPE;
4999: l_schedule_ship_date OE_ORDER_LINES_ALL.schedule_ship_date%TYPE;
5000: l_ordered_uom OE_ORDER_LINES_ALL.order_quantity_uom%TYPE;
5001: l_ordered_qty OE_ORDER_LINES_ALL.ordered_quantity%TYPE;
5002: l_org_id OE_ORDER_LINES_ALL.org_id%TYPE;
5003:
5004: -- Information from Replenishment PO Shipment
5005:
5006: l_replen_po_header_id PO_LINE_LOCATIONS_ALL.po_header_id%TYPE;

Line 5060: FROM OE_ORDER_LINES_ALL oola

5056: l_ordered_qty,
5057: l_ordered_uom,
5058: l_schedule_ship_date,
5059: l_org_id
5060: FROM OE_ORDER_LINES_ALL oola
5061: WHERE oola.line_id = p_replen_so_line_id;
5062:
5063: IF (g_fnd_debug = 'Y' AND
5064: FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE)

Line 5291: FROM oe_order_lines_all oola,

5287: FROM jmf_shikyu_components jsc
5288: WHERE jsc.shikyu_component_id = p_component_id
5289: AND jsc.subcontract_po_shipment_id = p_subcontract_po_shipment_id
5290: AND EXISTS (SELECT 'x'
5291: FROM oe_order_lines_all oola,
5292: oe_order_headers_all ooha
5293: WHERE oola.line_id = p_replen_so_line_id
5294: AND oola.inventory_item_id = p_component_id
5295: AND oola.price_list_id = jsc.price_list_id

Line 5375: FROM oe_order_lines_all oola

5371: WHERE mtlp.organization_id = jso.tp_organization_id
5372: AND jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
5373: AND ( (mtlp.project_control_level = 1
5374: AND EXISTS (SELECT 'x'
5375: FROM oe_order_lines_all oola
5376: WHERE oola.line_id = p_replen_so_line_id
5377: AND jso.project_id IS NOT NULL
5378: AND jso.project_id = oola.project_id
5379: AND NVL(jso.task_id, -1) = NVL(oola.task_id, -1)))

Line 5382: FROM oe_order_lines_all oola

5378: AND jso.project_id = oola.project_id
5379: AND NVL(jso.task_id, -1) = NVL(oola.task_id, -1)))
5380: OR (mtlp.project_control_level = 2
5381: AND EXISTS (SELECT 'x'
5382: FROM oe_order_lines_all oola
5383: WHERE oola.line_id = p_replen_so_line_id
5384: AND jso.project_id IS NOT NULL
5385: AND jso.task_id IS NOT NULL
5386: AND jso.project_id = oola.project_id

Line 5391: FROM oe_order_lines_all oola

5387: AND jso.task_id = oola.task_id))
5388: OR (jso.project_id IS NULL
5389: AND jso.task_id IS NULL
5390: AND EXISTS (SELECT 'x'
5391: FROM oe_order_lines_all oola
5392: WHERE oola.line_id = p_replen_so_line_id
5393: AND oola.project_id IS NULL
5394: AND oola.task_id IS NULL))
5395: );

Line 5697: l_line_id OE_ORDER_LINES_ALL.line_id%type;

5693: l_allocation_date DATE;
5694: l_return_status VARCHAR2(3);
5695: l_msg_count NUMBER;
5696: l_msg_data VARCHAR2(300);
5697: l_line_id OE_ORDER_LINES_ALL.line_id%type;
5698: l_cnt NUMBER;
5699: l_deleted_qty NUMBER;
5700: l_deletion_failed NUMBER := 0;
5701: l_deleted_allocations_tbl JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;

Line 5710: oe_order_lines_all oel

5706: jsr.oem_organization_id oem_organization_id,
5707: jsr.tp_organization_id tp_organization_id,
5708: oel.schedule_ship_date om_schedule_ship_date
5709: from jmf_shikyu_replenishments jsr,
5710: oe_order_lines_all oel
5711: where oel.line_id = jsr.replenishment_so_line_id
5712: and oel.schedule_ship_date <> jsr.schedule_ship_date
5713: and oel.actual_shipment_date is null --pick up only unshipped lines. Rescheduling can only be done if the line is not shipped though.
5714: and oel.open_flag = 'Y';