APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_LINES_MERGE_V

Line 372: FROM po_lines_merge_v

368: WHERE template_id = p_template_id;
369:
370: CURSOR c_get_usage_context1(p_line_id NUMBER, p_draft_id NUMBER) IS
371: SELECT CLM_IDC_TYPE, CONTRACT_TYPE
372: FROM po_lines_merge_v
373: WHERE PO_LINE_ID = p_line_id
374: AND DRAFT_ID = p_draft_id;
375:
376: CURSOR c_get_usage_context2(p_header_id NUMBER, p_draft_id NUMBER) IS

Line 1023: FROM po_lines_merge_v pll

1019: p_po_header_id NUMBER
1020: ,p_draft_id NUMBER
1021: )IS
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