DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on PO_ATTRIBUTE_VALUES

Line 5006: FROM PO_ATTRIBUTE_VALUES POAV

5002: OR
5003: (POAI.po_line_id <> g_NOT_REQUIRED_ID
5004: AND NOT EXISTS
5005: (SELECT 'Attribute row exists for PO Line'
5006: FROM PO_ATTRIBUTE_VALUES POAV
5007: WHERE POAV.po_line_id = POAI.po_line_id))
5008: -- IF RT keys is given, then Attr for RT line must exist
5009: OR
5010: (POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE

Line 5014: FROM PO_ATTRIBUTE_VALUES POAV

5010: (POAI.req_template_name <> g_NOT_REQUIRED_REQ_TEMPLATE
5011: AND POAI.req_template_line_num <> g_NOT_REQUIRED_ID
5012: AND NOT EXISTS
5013: (SELECT 'Attribute row exists for Req Template Line'
5014: FROM PO_ATTRIBUTE_VALUES POAV
5015: WHERE POAV.req_template_name = POAI.req_template_name
5016: AND POAV.req_template_line_num = POAI.req_template_line_num))
5017: )
5018: RETURNING POAI.interface_attr_values_id, POAI.interface_line_id, POAI.interface_header_id

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)))