[Home] [Help]
1090: SELECT
1091: item_type_code
1092: , NVL(shipped_quantity, fulfilled_quantity)
1093: FROM
1094: oe_order_lines_all
1095: WHERE line_id = l_link_to_line_id;
1096: BEGIN
1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1098: THEN
1657: SELECT
1658: item_type_code
1659: , NVL(shipped_quantity, fulfilled_quantity)
1660: FROM
1661: oe_order_lines_all
1662: WHERE line_id = l_link_to_line_id;
1663:
1664: CURSOR l_order_currency
1665: IS
2295: MAX(oola.line_id)
2296: , MAX(wdd.delivery_detail_id) picking_line_detail_id
2297: , MAX(wdd.organization_id) shipping_organization_id
2298: FROM
2299: oe_order_lines_all oola
2300: , wsh_delivery_details_ob_grp_v wdd
2301: WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11
2302: AND oola.orig_sys_document_ref = l_req_number
2303: AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
4017: mms.movement_id
4018: , mms.movement_status
4019: FROM
4020: mtl_movement_statistics mms
4021: , oe_order_lines_all oola
4022: WHERE mms.order_header_id = oola.reference_header_id
4023: AND mms.order_line_id = oola.reference_line_id
4024: AND oola.line_id = x_mvt_rma_transaction.order_line_id
4025: AND mms.entity_org_id = x_mvt_rma_transaction.entity_org_id
4564: CURSOR c_item_type IS
4565: SELECT
4566: oola2.item_type_code
4567: FROM
4568: oe_order_lines_all oola1
4569: , oe_order_lines_all oola2
4570: WHERE oola1.line_id = l_movement_transaction.order_line_id
4571: AND oola2.line_id = oola1.reference_line_id;
4572:
4565: SELECT
4566: oola2.item_type_code
4567: FROM
4568: oe_order_lines_all oola1
4569: , oe_order_lines_all oola2
4570: WHERE oola1.line_id = l_movement_transaction.order_line_id
4571: AND oola2.line_id = oola1.reference_line_id;
4572:
4573: BEGIN