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.PO_CATALOG_INDEX_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 465: FROM PO_REQEXPRESS_LINES_ALL

461: , p_reqexpress_name -- ReqTemplate Name
462: , sequence_num -- Reqtemplate Line Num
463: , org_id -- Org Id
464: , 'REQ_TEMPLATE' -- DATA INFO: Internal to PO
465: FROM PO_REQEXPRESS_LINES_ALL
466: WHERE express_name = p_reqexpress_name
467: AND org_id = p_org_id
468: and last_update_date between sysdate-1 and sysdate+1;
469:

Line 1590: FROM PO_REQEXPRESS_LINES_ALL PORTL

1586: l_req_template_name_list,
1587: l_req_template_line_num_list,
1588: l_req_template_org_id_list,
1589: l_item_description_list
1590: FROM PO_REQEXPRESS_LINES_ALL PORTL
1591: WHERE PORTL.express_name = p_reqexpress_name
1592: AND PORTL.org_id = p_org_id;
1593:
1594: IF g_debug_stmt THEN PO_DEBUG.debug_stmt(l_log_head,l_progress,'Number or REQ_TEMPLATE line descriptions selected to synch='||SQL%rowcount); END IF;

Line 1759: -- Get the list of category ids from PO_REQEXPRESS_LINES_ALL

1755:
1756: ELSIF (p_type = TYPE_REQ_TEMPLATE) THEN
1757:
1758: l_progress := '060';
1759: -- Get the list of category ids from PO_REQEXPRESS_LINES_ALL
1760: SELECT PORTL.express_name,
1761: PORTL.sequence_num,
1762: PORTL.org_id,
1763: PORTL.category_id,

Line 1771: FROM PO_REQEXPRESS_LINES_ALL PORTL,

1767: l_req_template_line_num_list,
1768: l_req_template_org_id_list,
1769: l_category_id_list,
1770: l_old_ip_category_id_list
1771: FROM PO_REQEXPRESS_LINES_ALL PORTL,
1772: PO_ATTRIBUTE_VALUES POATR
1773: WHERE PORTL.express_name = p_reqexpress_name
1774: AND PORTL.po_line_id = POATR.po_line_id
1775: AND PORTL.org_id = p_org_id;