DBA Data[Home] [Help]

APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_LINES_ALL_EXT_B

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