APPS.PO_UDA_AUTOCREATE_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 206: FROM po_uda_ag_template_usages tu, ego_attr_groups_v ag

202: l_progress := '010';
203:
204: SELECT DISTINCT ag.attr_group_name
205: BULK COLLECT INTO x_attr_group_tbl
206: FROM po_uda_ag_template_usages tu, ego_attr_groups_v ag
207: WHERE ag.attr_group_id = tu.attribute_group_id
208: AND tu.template_id = p_uda_template_id
209: AND tu.attribute_category NOT IN ('PRICING','DOCUMENT_NUMBERING'); --12611018 Document numbering added
210:

Line 1900: ,po_uda_ag_template_usages tu

1896: SELECT ag.attr_group_name
1897: BULK COLLECT INTO l_attr_group_tbl
1898: FROM pon_bid_item_prices_ext_b bid
1899: ,ego_attr_groups_v ag
1900: ,po_uda_ag_template_usages tu
1901: WHERE bid.bid_number = l_src_rec.bid_number
1902: AND bid.line_number = l_src_rec.bid_line_number
1903: AND bid.attr_group_id = ag.attr_group_id
1904: AND ag.attr_group_id = tu.attribute_group_id

Line 1949: ,po_uda_ag_template_usages tu

1945: SELECT ag.attr_group_name
1946: BULK COLLECT INTO l_attr_group_tbl
1947: FROM po_req_lines_ext_b req
1948: ,ego_attr_groups_v ag
1949: ,po_uda_ag_template_usages tu
1950: WHERE req.requisition_line_id = l_src_rec.requisition_line_id
1951: AND req.attr_group_id = ag.attr_group_id
1952: AND ag.attr_group_id = tu.attribute_group_id
1953: AND tu.template_id = l_src_template_id

Line 2588: po_uda_ag_template_usages pudat,

2584:
2585: SELECT distinct pudat.attribute_group_id
2586: BULK COLLECT INTO x_attr_group_id_tbl
2587: FROM po_headers_draft_all poh,
2588: po_uda_ag_template_usages pudat,
2589: EGO_ACTION_DISPLAYS_B ead,
2590: EGO_ACTIONS_B ea
2591: WHERE ea.action_id = ead.action_id
2592: AND ea.attr_group_id = pudat.attribute_group_id

Line 2604: po_uda_ag_template_usages pudat,

2600:
2601: SELECT distinct pudat.attribute_group_id
2602: BULK COLLECT INTO x_attr_group_id_tbl
2603: FROM po_headers_draft_all poh,
2604: po_uda_ag_template_usages pudat,
2605: EGO_ACTION_DISPLAYS_B ead,
2606: EGO_ACTIONS_B ea
2607: WHERE ea.action_id = ead.action_id
2608: AND ea.attr_group_id = pudat.attribute_group_id

Line 2623: po_uda_ag_template_usages pudat,

2619:
2620: SELECT distinct pudat.attribute_group_id
2621: BULK COLLECT INTO x_attr_group_id_tbl
2622: FROM po_headers_draft_all poh,
2623: po_uda_ag_template_usages pudat,
2624: EGO_ACTION_DISPLAYS_B ead,
2625: EGO_ACTIONS_B ea
2626: WHERE ea.action_id = ead.action_id
2627: AND ea.attr_group_id = pudat.attribute_group_id

Line 2643: po_uda_ag_template_usages pudat,

2639:
2640: SELECT distinct pudat.attribute_group_id
2641: BULK COLLECT INTO x_attr_group_id_tbl
2642: FROM po_headers_all poh,
2643: po_uda_ag_template_usages pudat,
2644: EGO_ACTION_DISPLAYS_B ead,
2645: EGO_ACTIONS_B ea
2646: WHERE ea.action_id = ead.action_id
2647: AND ea.attr_group_id = pudat.attribute_group_id

Line 2659: po_uda_ag_template_usages pudat,

2655:
2656: SELECT distinct pudat.attribute_group_id
2657: BULK COLLECT INTO x_attr_group_id_tbl
2658: FROM po_headers_all poh,
2659: po_uda_ag_template_usages pudat,
2660: EGO_ACTION_DISPLAYS_B ead,
2661: EGO_ACTIONS_B ea
2662: WHERE ea.action_id = ead.action_id
2663: AND ea.attr_group_id = pudat.attribute_group_id

Line 2678: po_uda_ag_template_usages pudat,

2674:
2675: SELECT distinct pudat.attribute_group_id
2676: BULK COLLECT INTO x_attr_group_id_tbl
2677: FROM po_headers_all poh,
2678: po_uda_ag_template_usages pudat,
2679: EGO_ACTION_DISPLAYS_B ead,
2680: EGO_ACTIONS_B ea
2681: WHERE ea.action_id = ead.action_id
2682: AND ea.attr_group_id = pudat.attribute_group_id