APPS.INV_RCV_COMMON_APIS dependencies on OE_ORDER_LINES

Line 4412: OE_ORDER_LINES_all OEL,

4408:
4409: SELECT DISTINCT(OEL.item_revision)
4410: INTO x_revision_code
4411: FROM
4412: OE_ORDER_LINES_all OEL,
4413: OE_ORDER_HEADERS_all OEH
4414: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4415: AND OEL.INVENTORY_ITEM_ID = p_item_id
4416: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id

Line 6294: FROM oe_order_lines l

6290:
6291: ELSIF p_document_type = 'RMA' THEN
6292: SELECT COUNT(COUNT(*))
6293: INTO l_project_tasks_count
6294: FROM oe_order_lines l
6295: WHERE l.line_category_code = 'RETURN'
6296: AND l.header_id = p_oe_header_id
6297: AND l.project_id IS NOT NULL
6298: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)

Line 6307: FROM oe_order_lines l

6303: GROUP BY project_id, task_id;
6304:
6305: SELECT COUNT(*)
6306: INTO l_distributions_count
6307: FROM oe_order_lines l
6308: WHERE l.line_category_code = 'RETURN'
6309: AND l.header_id = p_oe_header_id
6310: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)
6311: AND ( (p_item_rev IS NULL OR l.item_revision IS NULL) OR

Line 6345: FROM oe_order_lines l

6341: );
6342: ELSIF p_oe_header_id IS NOT NULL THEN
6343: SELECT COUNT(COUNT(*))
6344: INTO l_project_tasks_count
6345: FROM oe_order_lines l
6346: WHERE l.line_category_code = 'RETURN'
6347: AND l.header_id = p_oe_header_id
6348: AND l.project_id IS NOT NULL
6349: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)

Line 6358: FROM oe_order_lines l

6354: GROUP BY project_id, task_id;
6355:
6356: SELECT COUNT(*)
6357: INTO l_distributions_count
6358: FROM oe_order_lines l
6359: WHERE l.line_category_code = 'RETURN'
6360: AND l.header_id = p_oe_header_id
6361: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)
6362: AND ( (p_item_rev IS NULL OR l.item_revision IS NULL) OR

Line 6794: FROM oe_order_lines l

6790: ELSIF p_document_type = 'RMA' THEN
6791: BEGIN
6792: SELECT l.task_id
6793: INTO l_task_id
6794: FROM oe_order_lines l
6795: WHERE l.line_category_code = 'RETURN'
6796: AND l.header_id = p_oe_header_id
6797: AND l.project_id = p_project_id
6798: AND(p_item_id IS NULL

Line 6836: FROM oe_order_lines l

6832: ELSIF p_oe_header_id IS NOT NULL THEN
6833: BEGIN
6834: SELECT task_id
6835: INTO l_task_id
6836: FROM oe_order_lines l
6837: WHERE l.line_category_code = 'RETURN'
6838: AND l.header_id = p_oe_header_id
6839: AND l.project_id = p_project_id
6840: AND(p_item_id IS NULL