APPS.PON_TCA_MERGE_PVT dependencies on HZ_CODE_ASSIGNMENTS

Line 176: HZ_CODE_ASSIGNMENTS

172: SELECT 'BUYER' AS USER_TYPE
173: FROM
174: HZ_PARTIES USER_PARTIES,
175: HZ_RELATIONSHIPS,
176: HZ_CODE_ASSIGNMENTS
177: WHERE USER_PARTIES.PARTY_ID = p_user_party_id
178: AND HZ_RELATIONSHIPS.SUBJECT_ID = USER_PARTIES.PARTY_ID
179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

Line 183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID

179: AND HZ_RELATIONSHIPS.RELATIONSHIP_TYPE = 'POS_EMPLOYMENT'
180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
187: UNION

Line 184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'

180: AND HZ_RELATIONSHIPS.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
187: UNION
188: SELECT 'SELLER' AS USER_TYPE

Line 185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'

181: AND HZ_RELATIONSHIPS.START_DATE <= SYSDATE
182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
187: UNION
188: SELECT 'SELLER' AS USER_TYPE
189: FROM

Line 186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'

182: AND HZ_RELATIONSHIPS.END_DATE >= SYSDATE
183: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = HZ_RELATIONSHIPS.OBJECT_ID
184: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
185: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
186: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
187: UNION
188: SELECT 'SELLER' AS USER_TYPE
189: FROM
190: POS_SUPPLIER_USERS_V

Line 326: HZ_CODE_ASSIGNMENTS

322: IS
323: SELECT 'BUYER' AS COMPANY_TYPE
324: FROM
325: HZ_PARTIES USER_PARTIES,
326: HZ_CODE_ASSIGNMENTS
327: WHERE USER_PARTIES.PARTY_ID = p_party_id
328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID
330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'

Line 329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID

325: HZ_PARTIES USER_PARTIES,
326: HZ_CODE_ASSIGNMENTS
327: WHERE USER_PARTIES.PARTY_ID = p_party_id
328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID
330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
332: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
333: UNION

Line 330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'

326: HZ_CODE_ASSIGNMENTS
327: WHERE USER_PARTIES.PARTY_ID = p_party_id
328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID
330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
332: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
333: UNION
334: SELECT 'SELLER' AS COMPANY_TYPE

Line 331: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'

327: WHERE USER_PARTIES.PARTY_ID = p_party_id
328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID
330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
332: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
333: UNION
334: SELECT 'SELLER' AS COMPANY_TYPE
335: FROM

Line 332: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'

328: AND USER_PARTIES.PARTY_TYPE = 'ORGANIZATION'
329: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_ID = USER_PARTIES.PARTY_ID
330: AND HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME = 'HZ_PARTIES'
331: AND HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY = 'POS_PARTICIPANT_TYPE'
332: AND HZ_CODE_ASSIGNMENTS.CLASS_CODE = 'ENTERPRISE'
333: UNION
334: SELECT 'SELLER' AS COMPANY_TYPE
335: FROM
336: PO_VENDORS