DBA Data[Home] [Help]

APPS.PO_CATALOG_INDEX_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 458: FROM PO_REQEXPRESS_LINES_ALL

454: , p_reqexpress_name -- ReqTemplate Name
455: , sequence_num -- Reqtemplate Line Num
456: , org_id -- Org Id
457: , 'REQ_TEMPLATE' -- DATA INFO: Internal to PO
458: FROM PO_REQEXPRESS_LINES_ALL
459: WHERE express_name = p_reqexpress_name
460: AND org_id = p_org_id;
461:
462: l_num_rows_is_gt := SQL%rowcount;

Line 1552: FROM PO_REQEXPRESS_LINES_ALL PORTL

1548: l_req_template_name_list,
1549: l_req_template_line_num_list,
1550: l_req_template_org_id_list,
1551: l_item_description_list
1552: FROM PO_REQEXPRESS_LINES_ALL PORTL
1553: WHERE PORTL.express_name = p_reqexpress_name
1554: AND PORTL.org_id = p_org_id;
1555:
1556: 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 1721: -- Get the list of category ids from PO_REQEXPRESS_LINES_ALL

1717:
1718: ELSIF (p_type = TYPE_REQ_TEMPLATE) THEN
1719:
1720: l_progress := '060';
1721: -- Get the list of category ids from PO_REQEXPRESS_LINES_ALL
1722: SELECT PORTL.express_name,
1723: PORTL.sequence_num,
1724: PORTL.org_id,
1725: PORTL.category_id,

Line 1733: FROM PO_REQEXPRESS_LINES_ALL PORTL,

1729: l_req_template_line_num_list,
1730: l_req_template_org_id_list,
1731: l_category_id_list,
1732: l_old_ip_category_id_list
1733: FROM PO_REQEXPRESS_LINES_ALL PORTL,
1734: PO_ATTRIBUTE_VALUES POATR
1735: WHERE PORTL.express_name = p_reqexpress_name
1736: AND PORTL.po_line_id = POATR.po_line_id
1737: AND PORTL.org_id = p_org_id;