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.OE_SALES_CAN_UTIL dependencies on OE_LINE_SETS

Line 1747: FROM oe_order_lines ol, oe_sets OS, oe_line_sets ols

1743:
1744: -- Find all the non-closed fulfillment sets
1745: Cursor C_FulfillmentSets IS
1746: SELECT DISTINCT OS.SET_ID
1747: FROM oe_order_lines ol, oe_sets OS, oe_line_sets ols
1748: WHERE ol.header_id = p_header_id
1749: and OS.HEADER_ID = ol.header_id
1750: and ol.line_id = ols.line_id
1751: and ols.set_id = OS.set_id

Line 1769: FROM oe_order_lines ol, oe_line_sets ols

1765: LOOP
1766:
1767: -- Count the lines in this set
1768: SELECT count(1) INTO l_lines_in_set
1769: FROM oe_order_lines ol, oe_line_sets ols
1770: WHERE ol.header_id = p_header_id
1771: AND ols.set_id = C_Set.set_id
1772: AND ol.line_id = ols.line_id
1773: AND ol.cancelled_flag <> 'Y'

Line 1783: FROM oe_order_lines ol, oe_line_sets ols,

1779:
1780: -- Count the lines that are awaiting fulfillment for this set
1781: IF l_lines_in_set > 0 THEN
1782: SELECT count(1) INTO l_lines_awaiting
1783: FROM oe_order_lines ol, oe_line_sets ols,
1784: wf_item_activity_statuses WIAS,
1785: wf_process_activities WPA
1786: WHERE ol.header_id = p_header_id
1787: AND ols.set_id = C_Set.set_id

Line 1803: FROM oe_order_lines ol, oe_line_sets ols,

1799: IF l_lines_awaiting = l_lines_in_set THEN
1800: -- This is to pick up 1 line in the set in Fulfill:Notified
1801: SELECT WIAS.Process_Activity, ol.line_id
1802: INTO l_activity_id, l_line_id
1803: FROM oe_order_lines ol, oe_line_sets ols,
1804: wf_item_activity_statuses WIAS,
1805: wf_process_activities WPA
1806: WHERE ol.header_id = p_header_id
1807: AND ols.set_id = C_Set.set_id