[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'
792: po_headers_all ph,
793: po_lines_all pl,
794: icx_cat_items_ctx_hdrs_tlp ctxIn,
795: po_vendors pv,
796: po_line_types_b pltb
797: WHERE ph.global_agreement_flag = 'Y'
798: AND ph.po_header_id = t.po_header_id
799: AND ph.org_id <> t.organization_id
800: AND t.po_header_id = pl.po_header_id
870: po_headers_all ph,
871: po_lines_all pl,
872: icx_cat_items_ctx_hdrs_tlp ctxIn,
873: po_vendors pv,
874: po_line_types_b pltb
875: WHERE ph.global_agreement_flag = 'Y'
876: AND ph.po_header_id = t.po_header_id
877: AND ph.org_id <> t.organization_id
878: AND t.po_header_id = pl.po_header_id
989: po_lines_all pl,
990: po_session_gt pogt,
991: icx_cat_items_ctx_hdrs_tlp ctxIn,
992: po_vendors pv,
993: po_line_types_b pltb
994: WHERE ph.global_agreement_flag = 'Y'
995: AND ph.po_header_id = t.po_header_id
996: AND ph.org_id <> t.organization_id
997: AND ph.po_header_id = pl.po_header_id
1111: po_lines_all pl,
1112: po_session_gt pogt,
1113: icx_cat_items_ctx_hdrs_tlp ctxIn,
1114: po_vendors pv,
1115: po_line_types_b pltb
1116: WHERE ph.global_agreement_flag = 'Y'
1117: AND ph.po_header_id = t.po_header_id
1118: AND ph.org_id <> t.organization_id
1119: AND t.po_header_id = pl.po_header_id
1616: --Move the outside operation flag of a line type to the main cursor from the
1617: --status function due to the following reasons:
1618: --1. PO has confirmed that the outside operation flag
1619: -- of a line type cannot be changed once set
1620: --2. The main cursor anyways joins with po_line_types_b
1621: -- to eliminate the TEMP LABOR line
1622: IF (g_upgrade_last_run_date) IS NULL THEN
1623: l_err_loc := 400;
1624: OPEN l_bpa_quote_csr FOR
1695: FROM po_headers_all ph,
1696: po_lines_all pl,
1697: po_ga_org_assignments ga,
1698: po_attribute_values_tlp po_tlp,
1699: po_line_types_b pltb,
1700: icx_cat_categories_tl ic,
1701: po_vendors pv
1702: WHERE ph.po_header_id = pl.po_header_id
1703: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
1795: FROM po_headers_all ph,
1796: po_lines_all pl,
1797: po_ga_org_assignments ga,
1798: po_attribute_values_tlp po_tlp,
1799: po_line_types_b pltb,
1800: icx_cat_categories_tl ic,
1801: po_vendors pv
1802: WHERE ph.po_header_id = pl.po_header_id
1803: AND ph.type_lookup_code IN ('BLANKET', 'QUOTATION')
2290: --Move the outside operation flag of a line type to the main cursor from the
2291: --status function due to the following reasons:
2292: --1. PO has confirmed that the outside operation flag
2293: -- of a line type cannot be changed once set
2294: --2. The main cursor anyways joins with po_line_types_b
2295: -- to eliminate the TEMP LABOR line
2296: --3. Quote query uses an inline function because we check the existence of a price break at line level
2297: -- if header level approval_required_flag is Y.
2298: OPEN l_quote_csr FOR
2346: FROM po_headers_all ph,
2347: po_lines_all pl,
2348: po_session_gt pogt,
2349: po_attribute_values_tlp po_tlp,
2350: po_line_types_b pltb,
2351: icx_cat_categories_tl ic,
2352: po_vendors pv
2353: WHERE ph.po_header_id = pl.po_header_id
2354: AND ph.type_lookup_code = 'QUOTATION'