APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 2557: FROM ego_fnd_dsc_flx_ctx_ext ag

2553: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
2554: AND pel.lock_by_draft_id = p_draft_id )
2555: -- exclude multi-row attribute groups
2556: AND EXISTS (SELECT 'Single row attr grp'
2557: FROM ego_fnd_dsc_flx_ctx_ext ag
2558: WHERE phb1.attr_group_id = ag.attr_group_id
2559: AND ag.multi_row = 'N'
2560: )
2561: ) phb

Line 2898: FROM ego_fnd_dsc_flx_ctx_ext ag

2894: AND pel.entity_pk1= pheb.po_header_id
2895: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
2896: AND pel.lock_by_draft_id = p_draft_id )
2897: AND EXISTS (SELECT 'if multi row attr grp'
2898: FROM ego_fnd_dsc_flx_ctx_ext ag
2899: WHERE pheb.attr_group_id = ag.attr_group_id
2900: AND ag.multi_row = 'Y');
2901: d_position := 40;
2902: IF (PO_LOG.d_stmt) THEN

Line 3134: FROM ego_fnd_dsc_flx_ctx_ext ag

3130: AND pel.entity_pk1= phb.po_header_id
3131: AND pel.entity_name = PO_DRAFTS_PVT.G_LOCK_HEADER_ENTITY
3132: AND pel.lock_by_draft_id = p_draft_id )
3133: AND EXISTS (SELECT 'Multi row attr grp'
3134: FROM ego_fnd_dsc_flx_ctx_ext ag
3135: WHERE phb.attr_group_id = ag.attr_group_id
3136: AND ag.multi_row = 'Y');
3137:
3138: d_position :=60;

Line 3165: FROM ego_fnd_dsc_flx_ctx_ext ag

3161: DELETE FROM po_headers_all_ext_tl phaet
3162: WHERE phaet.po_header_id=l_po_header_id
3163: AND phaet.draft_id = p_draft_id
3164: AND EXISTS (SELECT 'if multi row attr grp'
3165: FROM ego_fnd_dsc_flx_ctx_ext ag
3166: WHERE phaet.attr_group_id = ag.attr_group_id
3167: AND ag.multi_row = 'Y')
3168: AND NOT EXISTS (SELECT 'only S or Null Locks'
3169: FROM po_entity_locks pel

Line 4674: FROM ego_fnd_dsc_flx_ctx_ext ag

4670: -- include addresses
4671: AND phbd.c_ext_attr40 ='PO_UDA_ADDRESS_TYPES'
4672: -- include multi-row attribute groups
4673: AND EXISTS (SELECT 'Multi row attr grp'
4674: FROM ego_fnd_dsc_flx_ctx_ext ag
4675: WHERE phbd.attr_group_id = ag.attr_group_id
4676: AND ag.multi_row = 'Y')
4677: AND NOT EXISTS (SELECT 'only S or Null Locks'
4678: FROM po_entity_locks pel