DBA Data[Home] [Help]

APPS.PO_FBO_PKG dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 311: ego_fnd_dsc_flx_ctx_ext ego,

307: ''Government Agency URL'') "desc")
308: "link"
309: )
310: FROM po_headers_all_ext_b phae,
311: ego_fnd_dsc_flx_ctx_ext ego,
312: po_lookup_codes plc,
313: po_vendors pv
314: WHERE phae.po_header_id = pha.po_header_id
315: AND phae.draft_id = -1

Line 508: ego_fnd_dsc_flx_ctx_ext ego

504: (pla.quantity * pla.unit_price))) total_amount,
505: c_ext_attr4
506: FROM po_lines_all_ext_b ple,
507: po_lines_all pla,
508: ego_fnd_dsc_flx_ctx_ext ego
509: WHERE pla.po_header_id = p_document_id
510: AND pla.po_line_id = ple.po_line_id
511: AND ple.draft_id = -1
512: AND ple.attr_group_id = ego.attr_group_id

Line 532: ego_fnd_dsc_flx_ctx_ext ego

528: Substr(c_ext_attr1, 1, 2),
529: Substr(c_ext_attr1, 1, 1))
530: INTO l_class_cod
531: FROM po_headers_all_ext_b phae,
532: ego_fnd_dsc_flx_ctx_ext ego
533: WHERE phae.po_header_id = p_document_id
534: AND phae.draft_id = -1
535: AND phae.attr_group_id = ego.attr_group_id
536: AND ego.descriptive_flexfield_name = 'PO_HEADER_EXT_ATTRS'

Line 590: ego_fnd_dsc_flx_ctx_ext ego

586: (pla.quantity * pla.unit_price))) total_amount,
587: c_ext_attr3
588: FROM po_lines_all_ext_b ple,
589: po_lines_all pla,
590: ego_fnd_dsc_flx_ctx_ext ego
591: WHERE pla.po_header_id = p_document_id
592: AND ple.draft_id = -1
593: AND pla.po_line_id = ple.po_line_id
594: AND ple.attr_group_id = ego.attr_group_id

Line 609: ego_fnd_dsc_flx_ctx_ext ego,

605: -- Check at header level (case :IDV without lines)
606: SELECT phae.C_EXT_ATTR4
607: INTO l_naics
608: FROM po_headers_all_ext_b phae,
609: ego_fnd_dsc_flx_ctx_ext ego,
610: po_lookup_codes plc
611: WHERE phae.po_header_id = p_document_id
612: AND phae.draft_id = -1
613: AND phae.attr_group_id = ego.attr_group_id