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.INV_RCV_COMMON_APIS dependencies on OE_ORDER_LINES

Line 3695: FROM oe_order_lines_all oel, oe_order_headers_all oeh

3691: l_progress := '20';
3692: BEGIN
3693: SELECT COUNT (DISTINCT oel.order_quantity_uom)
3694: INTO l_count
3695: FROM oe_order_lines_all oel, oe_order_headers_all oeh
3696: WHERE oel.header_id = p_order_header_id
3697: --AND oel.ordered_item_id = p_item_id -- commented for Bug 12640725
3698: AND oel.inventory_item_id = p_item_id -- added for Bug 12640725
3699: AND NVL (OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id

Line 3723: FROM oe_order_lines_all oel

3719: p_organization_id,
3720: --oel.ordered_item_id) -- commented for Bug 12640725
3721: oel.inventory_item_id) -- added for Bug 12640725
3722: INTO x_uom_code
3723: FROM oe_order_lines_all oel
3724: WHERE oel.header_id = p_order_header_id
3725: --AND oel.ordered_item_id = p_item_id -- commented for Bug 12640725
3726: AND oel.inventory_item_id = p_item_id -- added for Bug 12640725
3727: AND oel.line_category_code = 'RETURN'

Line 4935: OE_ORDER_LINES_all OEL,

4931:
4932: SELECT DISTINCT(OEL.item_revision)
4933: INTO x_revision_code
4934: FROM
4935: OE_ORDER_LINES_all OEL,
4936: OE_ORDER_HEADERS_all OEH
4937: WHERE OEL.LINE_CATEGORY_CODE='RETURN'
4938: AND OEL.INVENTORY_ITEM_ID = p_item_id
4939: AND nvl(OEL.SHIP_FROM_ORG_ID, OEH.SHIP_FROM_ORG_ID) = p_organization_id

Line 6826: FROM oe_order_lines l

6822:
6823: ELSIF p_document_type = 'RMA' THEN
6824: SELECT COUNT(COUNT(*))
6825: INTO l_project_tasks_count
6826: FROM oe_order_lines l
6827: WHERE l.line_category_code = 'RETURN'
6828: AND l.header_id = p_oe_header_id
6829: AND l.project_id IS NOT NULL
6830: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)

Line 6839: FROM oe_order_lines l

6835: GROUP BY project_id, task_id;
6836:
6837: SELECT COUNT(*)
6838: INTO l_distributions_count
6839: FROM oe_order_lines l
6840: WHERE l.line_category_code = 'RETURN'
6841: AND l.header_id = p_oe_header_id
6842: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)
6843: AND ( (p_item_rev IS NULL OR l.item_revision IS NULL) OR

Line 6877: FROM oe_order_lines l

6873: );
6874: ELSIF p_oe_header_id IS NOT NULL THEN
6875: SELECT COUNT(COUNT(*))
6876: INTO l_project_tasks_count
6877: FROM oe_order_lines l
6878: WHERE l.line_category_code = 'RETURN'
6879: AND l.header_id = p_oe_header_id
6880: AND l.project_id IS NOT NULL
6881: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)

Line 6890: FROM oe_order_lines l

6886: GROUP BY project_id, task_id;
6887:
6888: SELECT COUNT(*)
6889: INTO l_distributions_count
6890: FROM oe_order_lines l
6891: WHERE l.line_category_code = 'RETURN'
6892: AND l.header_id = p_oe_header_id
6893: AND (p_item_id IS NULL OR l.inventory_item_id = p_item_id)
6894: AND ( (p_item_rev IS NULL OR l.item_revision IS NULL) OR

Line 7326: FROM oe_order_lines l

7322: ELSIF p_document_type = 'RMA' THEN
7323: BEGIN
7324: SELECT l.task_id
7325: INTO l_task_id
7326: FROM oe_order_lines l
7327: WHERE l.line_category_code = 'RETURN'
7328: AND l.header_id = p_oe_header_id
7329: AND l.project_id = p_project_id
7330: AND(p_item_id IS NULL

Line 7368: FROM oe_order_lines l

7364: ELSIF p_oe_header_id IS NOT NULL THEN
7365: BEGIN
7366: SELECT task_id
7367: INTO l_task_id
7368: FROM oe_order_lines l
7369: WHERE l.line_category_code = 'RETURN'
7370: AND l.header_id = p_oe_header_id
7371: AND l.project_id = p_project_id
7372: AND(p_item_id IS NULL