[Home] [Help]
50: --Move the outside operation flag of a line type to the main cursor from the
51: --status function due to the following reasons:
52: --1. PO has confirmed that the outside operation flag
53: -- of a line type cannot be changed once set
54: --2. The main cursor anyways joins with po_line_types_b
55: -- to eliminate the TEMP LABOR line
56: OPEN l_bpa_csr FOR
57: SELECT /*+ LEADING(doc) */
58: doc.*,
120: po_lines_all pl,
121: po_ga_org_assignments ga,
122: po_session_gt pogt,
123: po_attribute_values_tlp po_tlp,
124: po_line_types_b pltb,
125: icx_cat_categories_tl ic,
126: po_vendors pv
127: WHERE ph.po_header_id = pl.po_header_id
128: AND ph.type_lookup_code = 'BLANKET'
255: po_lines_all pl,
256: po_ga_org_assignments ga,
257: po_session_gt pogt,
258: po_attribute_values_tlp po_tlp,
259: po_line_types_b pltb,
260: icx_cat_categories_tl ic,
261: po_vendors pv
262: WHERE ph.po_header_id = pl.po_header_id
263: AND ph.type_lookup_code = 'BLANKET'
796: po_headers_all ph,
797: po_lines_all pl,
798: icx_cat_items_ctx_hdrs_tlp ctxIn,
799: po_vendors pv,
800: po_line_types_b pltb
801: WHERE ph.global_agreement_flag = 'Y'
802: AND ph.po_header_id = t.po_header_id
803: AND ph.org_id <> t.organization_id
804: AND t.po_header_id = pl.po_header_id
874: po_headers_all ph,
875: po_lines_all pl,
876: icx_cat_items_ctx_hdrs_tlp ctxIn,
877: po_vendors pv,
878: po_line_types_b pltb
879: WHERE ph.global_agreement_flag = 'Y'
880: AND ph.po_header_id = t.po_header_id
881: AND ph.org_id <> t.organization_id
882: AND t.po_header_id = pl.po_header_id
993: po_lines_all pl,
994: po_session_gt pogt,
995: icx_cat_items_ctx_hdrs_tlp ctxIn,
996: po_vendors pv,
997: po_line_types_b pltb
998: WHERE ph.global_agreement_flag = 'Y'
999: AND ph.po_header_id = t.po_header_id
1000: AND ph.org_id <> t.organization_id
1001: AND ph.po_header_id = pl.po_header_id
1115: po_lines_all pl,
1116: po_session_gt pogt,
1117: icx_cat_items_ctx_hdrs_tlp ctxIn,
1118: po_vendors pv,
1119: po_line_types_b pltb
1120: WHERE ph.global_agreement_flag = 'Y'
1121: AND ph.po_header_id = t.po_header_id
1122: AND ph.org_id <> t.organization_id
1123: AND t.po_header_id = pl.po_header_id
1630: --Move the outside operation flag of a line type to the main cursor from the
1631: --status function due to the following reasons:
1632: --1. PO has confirmed that the outside operation flag
1633: -- of a line type cannot be changed once set
1634: --2. The main cursor anyways joins with po_line_types_b
1635: -- to eliminate the TEMP LABOR line
1636: IF (g_upgrade_last_run_date) IS NULL THEN
1637: l_err_loc := 400;
1638: OPEN l_bpa_quote_csr FOR
1709: FROM po_headers_all ph,
1710: po_lines_all pl,
1711: po_ga_org_assignments ga,
1712: po_attribute_values_tlp po_tlp,
1713: po_line_types_b pltb,
1714: icx_cat_categories_tl ic,
1715: po_vendors pv
1716: WHERE ph.po_header_id = pl.po_header_id
1717: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
1809: FROM po_headers_all ph,
1810: po_lines_all pl,
1811: po_ga_org_assignments ga,
1812: po_attribute_values_tlp po_tlp,
1813: po_line_types_b pltb,
1814: icx_cat_categories_tl ic,
1815: po_vendors pv
1816: WHERE ph.po_header_id = pl.po_header_id
1817: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
2304: --Move the outside operation flag of a line type to the main cursor from the
2305: --status function due to the following reasons:
2306: --1. PO has confirmed that the outside operation flag
2307: -- of a line type cannot be changed once set
2308: --2. The main cursor anyways joins with po_line_types_b
2309: -- to eliminate the TEMP LABOR line
2310: --3. Quote query uses an inline function because we check the existence of a price break at line level
2311: -- if header level approval_required_flag is Y.
2312: OPEN l_quote_csr FOR
2360: FROM po_headers_all ph,
2361: po_lines_all pl,
2362: po_session_gt pogt,
2363: po_attribute_values_tlp po_tlp,
2364: po_line_types_b pltb,
2365: icx_cat_categories_tl ic,
2366: po_vendors pv
2367: WHERE ph.po_header_id = pl.po_header_id
2368: AND ph.type_lookup_code = 'QUOTATION'