APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP

Line 5100: FROM PO_ATTRIBUTE_VALUES_TLP POTLP

5096: OR
5097: (POATI.po_line_id <> g_NOT_REQUIRED_ID
5098: AND NOT EXISTS
5099: (SELECT 'Attribute TLP row exists for PO Line'
5100: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
5101: WHERE POTLP.po_line_id = POATI.po_line_id
5102: AND POTLP.language = POATI.language))
5103: -- IF RT keys is given, then:
5104: -- 1. ORG_ID must be given

Line 5112: FROM PO_ATTRIBUTE_VALUES_TLP POTLP

5108: AND POATI.req_template_line_num <> g_NOT_REQUIRED_ID
5109: AND (POATI.org_id = g_NOT_REQUIRED_ID OR
5110: NOT EXISTS
5111: (SELECT 'Attribute row exists for Req Template Line'
5112: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
5113: WHERE POTLP.req_template_name = POATI.req_template_name
5114: AND POTLP.req_template_line_num = POATI.req_template_line_num
5115: AND POTLP.org_id = POATI.org_id
5116: AND POTLP.language = POATI.language)))

Line 5410: FROM PO_ATTRIBUTE_VALUES_TLP POTLP

5406: OR
5407: (POATI.po_line_id <> g_NOT_REQUIRED_ID
5408: AND NOT EXISTS
5409: (SELECT 'Attribute TLP row exists for PO Line'
5410: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
5411: WHERE POTLP.po_line_id = POATI.po_line_id
5412: AND POTLP.language = POATI.language))
5413: -- IF RT keys is given, then:
5414: -- 1. ORG_ID must be given

Line 5422: FROM PO_ATTRIBUTE_VALUES_TLP POTLP

5418: AND POATI.req_template_line_num <> g_NOT_REQUIRED_ID
5419: AND (POATI.org_id = g_NOT_REQUIRED_ID OR
5420: NOT EXISTS
5421: (SELECT 'Attribute row exists for Req Template Line'
5422: FROM PO_ATTRIBUTE_VALUES_TLP POTLP
5423: WHERE POTLP.req_template_name = POATI.req_template_name
5424: AND POTLP.req_template_line_num = POATI.req_template_line_num
5425: AND POTLP.org_id = POATI.org_id
5426: AND POTLP.language = POATI.language)))