APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_LINES_ALL

Line 566: FROM PO_LINES_ALL_EXT_B

562: AND DRAFT_ID = p_draft_id;
563:
564: CURSOR c_po_line_ext(p_line_id NUMBER, p_draft_id NUMBER) IS
565: SELECT DISTINCT ATTR_GROUP_ID
566: FROM PO_LINES_ALL_EXT_B
567: WHERE PO_LINE_ID = p_line_id
568: AND DRAFT_ID = p_draft_id;
569:
570: CURSOR c_po_location_ext(p_location_id NUMBER, p_draft_id NUMBER) IS

Line 1535: from po_Lines_all_ext_b

1531:
1532: BEGIN
1533: select 1
1534: into l_present
1535: from po_Lines_all_ext_b
1536: where po_line_id = c_get_lines_rec.PO_LINE_ID
1537: and draft_id = l_draft_id
1538: AND ROWNUM < 2;
1539: EXCEPTION

Line 2205: FROM PO_LINES_ALL_EXT_B

2201: WHERE PO_HEADER_ID = p_header_id;
2202:
2203: CURSOR c_po_line_ext(p_line_id NUMBER) IS
2204: SELECT DISTINCT ATTR_GROUP_ID
2205: FROM PO_LINES_ALL_EXT_B
2206: WHERE PO_LINE_ID = p_line_id;
2207:
2208: CURSOR c_po_location_ext(p_location_id NUMBER) IS
2209: SELECT DISTINCT ATTR_GROUP_ID

Line 2670: FROM po_lines_all pll

2666: l_msg_data VARCHAR2(100);
2667:
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

Line 2739: FROM po_lines_all

2735:
2736: BEGIN
2737: SELECT UDA_TEMPLATE_ID
2738: INTO l_line_template_id
2739: FROM po_lines_all
2740: WHERE PO_LINE_ID = c_get_lines_rec.PO_LINE_ID;
2741:
2742: PO_UDA_DEFAULTING_PKG.DEBUG('Line ID is'|| c_get_lines_rec.PO_LINE_ID, d_progress);
2743: PO_UDA_DEFAULTING_PKG.DEBUG('l_line_template_id :' || l_line_template_id , d_progress);