DBA Data[Home] [Help]

APPS.PO_DRAFTS_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 5744: ego_fnd_dsc_flx_ctx_ext ag

5740: ) p_lock_attrs,
5741: phb.attr_group_id
5742: FROM po_headers_all_ext_b phb,
5743: po_session_gt pogt,
5744: ego_fnd_dsc_flx_ctx_ext ag
5745: WHERE phb.po_header_id = pogt.char1 -- po_header_id
5746: AND phb.draft_id = G_DRAFT_ID_MINUS_1
5747: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
5748: AND pogt.index_char2 = G_LOCK_HEADER_ENTITY

Line 5849: ego_fnd_dsc_flx_ctx_ext ag

5845: ) p_lock_attrs,
5846: phbd.attr_group_id
5847: FROM po_headers_all_ext_b phbd,
5848: po_session_gt pogt,
5849: ego_fnd_dsc_flx_ctx_ext ag
5850: WHERE phbd.draft_id = p_draft_id
5851: AND phbd.po_header_id = pogt.char1 -- po_header_id
5852: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
5853: AND pogt.index_char2 = G_LOCK_HEADER_ENTITY

Line 5900: ego_fnd_dsc_flx_ctx_ext ag

5896: AND pogt.index_char2 = G_LOCK_HEADER_ENTITY
5897: AND EXISTS (SELECT draft.attr_group_id
5898: FROM po_headers_all_ext_b draft,
5899: po_uda_ag_template_usages uda_usg,
5900: ego_fnd_dsc_flx_ctx_ext ag
5901: WHERE draft.po_header_id = l_po_header_id
5902: AND draft.draft_id = p_draft_id
5903: AND draft.uda_template_id = uda_usg.template_id
5904: AND draft.attr_group_id = uda_usg.attribute_group_id

Line 5912: ego_fnd_dsc_flx_ctx_ext ag

5908: MINUS
5909: SELECT base.attr_group_id
5910: FROM po_headers_all_ext_b base,
5911: po_uda_ag_template_usages uda_usg,
5912: ego_fnd_dsc_flx_ctx_ext ag
5913: WHERE base.po_header_id = l_po_header_id
5914: AND base.draft_id = -1
5915: AND base.uda_template_id = uda_usg.template_id
5916: AND base.attr_group_id = uda_usg.attribute_group_id

Line 6043: ego_fnd_dsc_flx_ctx_ext ag

6039: d_ext_attr8,
6040: d_ext_attr9,
6041: d_ext_attr10
6042: FROM po_headers_all_ext_b pohextb,
6043: ego_fnd_dsc_flx_ctx_ext ag
6044: WHERE pohextb.po_header_id = pohd.po_header_id
6045: AND pohextb.draft_id = p_draft_id
6046: AND pohextb.attr_group_id = ag.attr_group_id
6047: AND ag.multi_row = 'Y'

Line 6142: ego_fnd_dsc_flx_ctx_ext ag

6138: d_ext_attr8,
6139: d_ext_attr9,
6140: d_ext_attr10
6141: FROM po_headers_all_ext_b pohextb,
6142: ego_fnd_dsc_flx_ctx_ext ag
6143: WHERE pohextb.po_header_id = pohd.po_header_id
6144: AND pohextb.draft_id = G_DRAFT_ID_MINUS_1
6145: AND pohextb.attr_group_id = ag.attr_group_id
6146: AND ag.multi_row = 'Y'

Line 6242: ego_fnd_dsc_flx_ctx_ext ag

6238: d_ext_attr8,
6239: d_ext_attr9,
6240: d_ext_attr10
6241: FROM po_headers_all_ext_b pohextb,
6242: ego_fnd_dsc_flx_ctx_ext ag
6243: WHERE pohextb.po_header_id = pohd.po_header_id
6244: AND pohextb.draft_id = G_DRAFT_ID_MINUS_1
6245: AND pohextb.attr_group_id = ag.attr_group_id
6246: AND ag.multi_row = 'Y'

Line 6341: ego_fnd_dsc_flx_ctx_ext ag

6337: d_ext_attr8,
6338: d_ext_attr9,
6339: d_ext_attr10
6340: FROM po_headers_all_ext_b pohextb,
6341: ego_fnd_dsc_flx_ctx_ext ag
6342: WHERE pohextb.po_header_id = pohd.po_header_id
6343: AND pohextb.draft_id = p_draft_id
6344: AND pohextb.attr_group_id = ag.attr_group_id
6345: AND ag.multi_row = 'Y'