DBA Data[Home] [Help]

APPS.PO_UDA_DEFAULTING_PKG dependencies on EGO_ACTION_DISPLAYS_B

Line 1026: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

1022: SELECT PO_LINE_ID, ITEM_ID, LINE_TYPE_ID
1023: FROM po_lines_merge_v pll
1024: WHERE PO_HEADER_ID = p_po_header_id
1025: AND DRAFT_ID = p_draft_id
1026: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
1027: WHERE act.action_id = actdisp.action_id
1028: AND pousage.template_id = pll.uda_template_id
1029: AND pousage.attribute_group_id = act.attr_group_id
1030: AND To_Char(pousage.template_id) = act.classification_code

Line 1043: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

1039: FROM po_line_locations_merge_v pll
1040: WHERE PO_HEADER_ID = p_po_header_id
1041: AND PO_LINE_ID = p_line_id
1042: AND DRAFT_ID = p_draft_id
1043: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
1044: WHERE act.action_id = actdisp.action_id
1045: AND pousage.template_id = pll.uda_template_id
1046: AND pousage.attribute_group_id = act.attr_group_id
1047: AND To_Char(pousage.template_id) = act.classification_code

Line 2672: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

2668: CURSOR c_get_lines(p_po_header_id NUMBER) IS
2669: SELECT PO_LINE_ID
2670: FROM po_lines_all pll
2671: WHERE PO_HEADER_ID = p_po_header_id
2672: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
2673: WHERE act.action_id = actdisp.action_id
2674: AND pousage.template_id = pll.uda_template_id
2675: AND pousage.attribute_group_id = act.attr_group_id
2676: AND To_Char(pousage.template_id) = act.classification_code

Line 2688: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

2684: SELECT LINE_LOCATION_ID
2685: FROM PO_LINE_LOCATIONS_all pll
2686: WHERE PO_HEADER_ID = p_po_header_id
2687: AND PO_LINE_ID = p_line_id
2688: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
2689: WHERE act.action_id = actdisp.action_id
2690: AND pousage.template_id = pll.uda_template_id
2691: AND pousage.attribute_group_id = act.attr_group_id
2692: AND To_Char(pousage.template_id) = act.classification_code