DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 2727: po_uda_ag_template_usages tu

2723: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2724: INTO l_attr_group_tbl
2725: FROM po_lines_all_ext_b ple ,
2726: ego_attr_groups_v ag ,
2727: po_uda_ag_template_usages tu
2728: WHERE ple.po_line_id = p_po_line_id_tbl(i)
2729: AND ple.attr_group_id = ag.attr_group_id
2730: AND ag.attr_group_id = tu.attribute_group_id
2731: AND tu.template_id = l_src_template_id

Line 2851: po_uda_ag_template_usages tu

2847: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2848: INTO x_attr_group_tbl
2849: FROM po_lines_all_ext_b ple ,
2850: ego_attr_groups_v ag ,
2851: po_uda_ag_template_usages tu
2852: WHERE ple.po_line_id = p_po_line_id_tbl(i)
2853: AND ple.attr_group_id = ag.attr_group_id
2854: AND ag.attr_group_id = tu.attribute_group_id
2855: AND tu.template_id = ple.uda_template_id

Line 2902: po_uda_ag_template_usages tu

2898: SELECT DISTINCT ag.attr_group_name BULK COLLECT
2899: INTO x_attr_group_tbl
2900: FROM po_line_locations_all_ext_b plle ,
2901: ego_attr_groups_v ag ,
2902: po_uda_ag_template_usages tu
2903: WHERE plle.line_location_id = p_line_location_id_tbl(i)
2904: AND plle.attr_group_id = ag.attr_group_id
2905: AND ag.attr_group_id = tu.attribute_group_id
2906: AND tu.template_id = plle.uda_template_id;