eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_ORDER_HOLDS_ALL

Line 4393: -- This procedure is added to update the Credit Profile Lvel in OE_ORDER_HOLDS_ALL table

4389: END Update_Released_Amount;
4390:
4391: --------------------------------------------------------------------------------------------
4392: -- Procedure Update_Credit_Profile_Level
4393: -- This procedure is added to update the Credit Profile Lvel in OE_ORDER_HOLDS_ALL table
4394: -- that will be used to decide if the Bill to Change should trigger Credit Checing or not.
4395: --------------------------------------------------------------------------------------------
4396: PROCEDURE Update_Credit_Profile_Level(
4397: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type)

Line 4455: UPDATE OE_ORDER_HOLDS_ALL

4451: oe_debug_pub.add('OEXUCRCB: Retrieved Hold Source Id: '|| l_hold_source_id);
4452: END IF;
4453: END IF;
4454:
4455: UPDATE OE_ORDER_HOLDS_ALL
4456: SET Credit_Profile_Level=OE_Credit_Engine_GRP.G_Credit_Profile_Level,
4457: Last_Update_Date = SYSDATE,
4458: Last_Updated_By = FND_GLOBAL.user_id
4459: WHERE hold_source_id = l_hold_source_id;

Line 6194: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880589 FTS on OE_ORDER_HOLDS_ALL)

6190: AND h.booked_flag = 'Y'
6191: AND l.open_flag = 'Y'
6192: AND h.header_id <> l_header_id
6193: AND NOT EXISTS ( SELECT 1
6194: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880589 FTS on OE_ORDER_HOLDS_ALL)
6195: WHERE h.header_id = oh.header_id
6196: AND oh.hold_release_id IS NULL )
6197: AND h.transactional_curr_code = p_curr_code
6198: AND (EXISTS

Line 6236: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880618 FTS on OE_ORDER_HOLDS_ALL)

6232: AND h.booked_flag = 'Y'
6233: AND l.open_flag = 'Y'
6234: AND h.header_id <> l_header_id
6235: AND NOT EXISTS ( SELECT 1
6236: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880618 FTS on OE_ORDER_HOLDS_ALL)
6237: WHERE h.header_id = oh.header_id
6238: AND oh.hold_release_id IS NULL )
6239: AND h.transactional_curr_code = p_curr_code
6240: AND (EXISTS

Line 6276: FROM oe_order_holds_all oh

6272: AND h.booked_flag = 'Y'
6273: AND l.open_flag = 'Y'
6274: AND h.header_id <> l_header_id
6275: AND EXISTS ( SELECT 1
6276: FROM oe_order_holds_all oh
6277: WHERE h.header_id = oh.header_id
6278: AND oh.hold_release_id IS NULL )
6279: AND h.transactional_curr_code = p_curr_code
6280: AND (EXISTS

Line 6319: FROM oe_order_holds_all oh

6315: AND h.booked_flag = 'Y'
6316: AND l.open_flag = 'Y'
6317: AND h.header_id <> l_header_id
6318: AND EXISTS ( SELECT 1
6319: FROM oe_order_holds_all oh
6320: WHERE h.header_id = oh.header_id
6321: AND oh.hold_release_id IS NULL )
6322: AND h.transactional_curr_code = p_curr_code
6323: AND (EXISTS

Line 6566: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880775 FTS on OE_ORDER_HOLDS_ALL)

6562: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6563: AND h.transactional_curr_code = p_curr_code
6564: AND h.header_id <> l_header_id
6565: AND NOT EXISTS ( SELECT 1
6566: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880775 FTS on OE_ORDER_HOLDS_ALL)
6567: WHERE h.header_id = oh.header_id
6568: AND oh.line_id IS NULL
6569: AND oh.hold_release_id IS NULL )
6570: AND (EXISTS

Line 6619: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880801 FTS on OE_ORDER_HOLDS_ALL)

6615: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6616: AND h.transactional_curr_code = p_curr_code
6617: AND h.header_id <> l_header_id
6618: AND NOT EXISTS ( SELECT 1
6619: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880801 FTS on OE_ORDER_HOLDS_ALL)
6620: WHERE h.header_id = oh.header_id
6621: AND oh.line_id IS NULL
6622: AND oh.hold_release_id IS NULL )
6623: AND (EXISTS

Line 6673: FROM oe_order_holds_all oh

6669: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6670: AND h.transactional_curr_code = p_curr_code
6671: AND h.header_id <> l_header_id
6672: AND EXISTS ( SELECT 1
6673: FROM oe_order_holds_all oh
6674: WHERE h.header_id = oh.header_id
6675: AND oh.line_id IS NULL
6676: AND oh.hold_release_id IS NULL )
6677: AND (EXISTS

Line 6728: FROM oe_order_holds_all oh

6724: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6725: AND h.transactional_curr_code = p_curr_code
6726: AND h.header_id <> l_header_id
6727: AND EXISTS ( SELECT 1
6728: FROM oe_order_holds_all oh
6729: WHERE h.header_id = oh.header_id
6730: AND oh.line_id IS NULL
6731: AND oh.hold_release_id IS NULL )
6732: AND (EXISTS

Line 6771: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)

6767: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
6768: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6769: AND h.header_id <> l_header_id
6770: AND NOT EXISTS ( SELECT 1
6771: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)
6772: WHERE h.header_id = oh.header_id
6773: AND oh.line_id IS NULL
6774: AND oh.hold_release_id IS NULL )
6775: AND EXISTS

Line 6778: oe_order_lines_all l --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)

6774: AND oh.hold_release_id IS NULL )
6775: AND EXISTS
6776: (SELECT NULL
6777: FROM oe_payment_types_all pt,
6778: oe_order_lines_all l --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)
6779: WHERE pt.credit_check_flag = 'Y'
6780: AND l.header_id = h.header_id
6781: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6782: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 6820: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)

6816: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
6817: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6818: AND h.header_id <> l_header_id
6819: AND NOT EXISTS ( SELECT 1
6820: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)
6821: WHERE h.header_id = oh.header_id
6822: AND oh.line_id IS NULL
6823: AND oh.hold_release_id IS NULL )
6824: AND EXISTS

Line 6827: oe_order_lines_all l --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)

6823: AND oh.hold_release_id IS NULL )
6824: AND EXISTS
6825: (SELECT NULL
6826: FROM oe_payment_types_all pt,
6827: oe_order_lines_all l --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)
6828: WHERE pt.credit_check_flag = 'Y'
6829: AND l.header_id = h.header_id
6830: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6831: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 6868: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)

6864: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
6865: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6866: AND h.header_id <> l_header_id
6867: AND EXISTS ( SELECT 1
6868: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)
6869: WHERE h.header_id = oh.header_id
6870: AND oh.line_id IS NULL
6871: AND oh.hold_release_id IS NULL )
6872: AND EXISTS

Line 6875: oe_order_lines_all l --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)

6871: AND oh.hold_release_id IS NULL )
6872: AND EXISTS
6873: (SELECT NULL
6874: FROM oe_payment_types_all pt,
6875: oe_order_lines_all l --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)
6876: WHERE pt.credit_check_flag = 'Y'
6877: AND l.header_id = h.header_id
6878: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */
6879: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 6917: FROM oe_order_holds_all oh

6913: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
6914: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6915: AND h.header_id <> l_header_id
6916: AND EXISTS ( SELECT 1
6917: FROM oe_order_holds_all oh
6918: WHERE h.header_id = oh.header_id
6919: AND oh.line_id IS NULL
6920: AND oh.hold_release_id IS NULL )
6921: AND EXISTS

Line 7129: FROM oe_order_holds_all oh

7125: AND h.booked_flag = 'Y'
7126: AND l.open_flag = 'Y'
7127: AND h.header_id <> l_header_id
7128: AND NOT EXISTS ( SELECT 1
7129: FROM oe_order_holds_all oh
7130: WHERE h.header_id = oh.header_id
7131: AND oh.hold_release_id IS NULL )
7132: AND h.transactional_curr_code = p_curr_code
7133: AND (EXISTS

Line 7168: FROM oe_order_holds_all oh

7164: AND h.booked_flag = 'Y'
7165: AND l.open_flag = 'Y'
7166: AND h.header_id <> l_header_id
7167: AND NOT EXISTS ( SELECT 1
7168: FROM oe_order_holds_all oh
7169: WHERE h.header_id = oh.header_id
7170: AND oh.hold_release_id IS NULL )
7171: AND h.transactional_curr_code = p_curr_code
7172: AND (EXISTS

Line 7203: FROM oe_order_holds_all oh

7199: AND h.booked_flag = 'Y'
7200: AND l.open_flag = 'Y'
7201: AND h.header_id <> l_header_id
7202: AND EXISTS ( SELECT 1
7203: FROM oe_order_holds_all oh
7204: WHERE h.header_id = oh.header_id
7205: AND oh.hold_release_id IS NULL )
7206: AND h.transactional_curr_code = p_curr_code
7207: AND (EXISTS

Line 7239: FROM oe_order_holds_all oh --Performance issue (SQL ID-14881132 FTS on OE_ORDER_HOLDS_ALL)

7235: AND h.booked_flag = 'Y'
7236: AND l.open_flag = 'Y'
7237: AND h.header_id <> l_header_id
7238: AND EXISTS ( SELECT 1
7239: FROM oe_order_holds_all oh --Performance issue (SQL ID-14881132 FTS on OE_ORDER_HOLDS_ALL)
7240: WHERE h.header_id = oh.header_id
7241: AND oh.hold_release_id IS NULL )
7242: AND h.transactional_curr_code = p_curr_code
7243: AND (EXISTS

Line 7452: FROM oe_order_holds_all oh --Modified the query to access oe_order_holds_all

7448: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7449: AND h.transactional_curr_code = p_curr_code
7450: AND h.header_id <> l_header_id
7451: AND NOT EXISTS ( SELECT 1
7452: FROM oe_order_holds_all oh --Modified the query to access oe_order_holds_all
7453: WHERE h.header_id = oh.header_id --instead of oe_order_holds to avoid FTS (SQL ID#14881276)
7454: AND oh.line_id IS NULL
7455: AND oh.hold_release_id IS NULL )
7456: AND (EXISTS

Line 7501: FROM oe_order_holds_all oh --Modified the query to select from

7497: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7498: AND h.transactional_curr_code = p_curr_code
7499: AND h.header_id <> l_header_id
7500: AND NOT EXISTS ( SELECT 1
7501: FROM oe_order_holds_all oh --Modified the query to select from
7502: WHERE h.header_id = oh.header_id --oe_order_holds_all to avoid FTS (SQL#14881293)
7503: AND oh.line_id IS NULL
7504: AND oh.hold_release_id IS NULL )
7505: AND (EXISTS

Line 7502: WHERE h.header_id = oh.header_id --oe_order_holds_all to avoid FTS (SQL#14881293)

7498: AND h.transactional_curr_code = p_curr_code
7499: AND h.header_id <> l_header_id
7500: AND NOT EXISTS ( SELECT 1
7501: FROM oe_order_holds_all oh --Modified the query to select from
7502: WHERE h.header_id = oh.header_id --oe_order_holds_all to avoid FTS (SQL#14881293)
7503: AND oh.line_id IS NULL
7504: AND oh.hold_release_id IS NULL )
7505: AND (EXISTS
7506: (SELECT NULL

Line 7549: FROM oe_order_holds_all oh

7545: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7546: AND h.transactional_curr_code = p_curr_code
7547: AND h.header_id <> l_header_id
7548: AND EXISTS ( SELECT 1
7549: FROM oe_order_holds_all oh
7550: WHERE h.header_id = oh.header_id
7551: AND oh.line_id IS NULL
7552: AND oh.hold_release_id IS NULL )
7553: AND (EXISTS

Line 7597: FROM oe_order_holds_all oh

7593: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7594: AND h.transactional_curr_code = p_curr_code
7595: AND h.header_id <> l_header_id
7596: AND EXISTS ( SELECT 1
7597: FROM oe_order_holds_all oh
7598: WHERE h.header_id = oh.header_id
7599: AND oh.line_id IS NULL
7600: AND oh.hold_release_id IS NULL )
7601: AND EXISTS

Line 7641: FROM oe_order_holds_all oh

7637: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
7638: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7639: AND h.header_id <> l_header_id
7640: AND NOT EXISTS ( SELECT 1
7641: FROM oe_order_holds_all oh
7642: WHERE h.header_id = oh.header_id
7643: AND oh.line_id IS NULL
7644: AND oh.hold_release_id IS NULL )
7645: AND EXISTS

Line 7686: FROM oe_order_holds_all oh

7682: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
7683: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7684: AND h.header_id <> l_header_id
7685: AND NOT EXISTS ( SELECT 1
7686: FROM oe_order_holds_all oh
7687: WHERE h.header_id = oh.header_id
7688: AND oh.line_id IS NULL
7689: AND oh.hold_release_id IS NULL )
7690: AND EXISTS

Line 7730: FROM oe_order_holds_all oh

7726: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
7727: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7728: AND h.header_id <> l_header_id
7729: AND EXISTS ( SELECT 1
7730: FROM oe_order_holds_all oh
7731: WHERE h.header_id = oh.header_id
7732: AND oh.line_id IS NULL
7733: AND oh.hold_release_id IS NULL )
7734: AND EXISTS

Line 7774: FROM oe_order_holds_all oh

7770: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
7771: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7772: AND h.header_id <> l_header_id
7773: AND EXISTS ( SELECT 1
7774: FROM oe_order_holds_all oh
7775: WHERE h.header_id = oh.header_id
7776: AND oh.line_id IS NULL
7777: AND oh.hold_release_id IS NULL )
7778: AND EXISTS

Line 8155: FROM oe_order_holds_ALL oh

8151: AND h.booked_flag = 'Y'
8152: AND l.open_flag = 'Y'
8153: AND h.header_id <> l_header_id
8154: AND NOT EXISTS ( SELECT 1
8155: FROM oe_order_holds_ALL oh
8156: WHERE h.header_id = oh.header_id
8157: AND oh.hold_release_id IS NULL )
8158: AND h.transactional_curr_code = p_curr_code
8159: AND (EXISTS

Line 8197: FROM oe_order_holds_ALL oh

8193: AND h.booked_flag = 'Y'
8194: AND l.open_flag = 'Y'
8195: AND h.header_id <> l_header_id
8196: AND NOT EXISTS ( SELECT 1
8197: FROM oe_order_holds_ALL oh
8198: WHERE h.header_id = oh.header_id
8199: AND oh.hold_release_id IS NULL )
8200: AND h.transactional_curr_code = p_curr_code
8201: AND (EXISTS

Line 8237: FROM oe_order_holds_ALL oh

8233: AND h.booked_flag = 'Y'
8234: AND l.open_flag = 'Y'
8235: AND h.header_id <> l_header_id
8236: AND EXISTS ( SELECT 1
8237: FROM oe_order_holds_ALL oh
8238: WHERE h.header_id = oh.header_id
8239: AND oh.hold_release_id IS NULL )
8240: AND h.transactional_curr_code = p_curr_code
8241: AND (EXISTS

Line 8278: FROM oe_order_holds_ALL oh

8274: AND h.booked_flag = 'Y'
8275: AND l.open_flag = 'Y'
8276: AND h.header_id <> l_header_id
8277: AND EXISTS ( SELECT 1
8278: FROM oe_order_holds_ALL oh
8279: WHERE h.header_id = oh.header_id
8280: AND oh.hold_release_id IS NULL )
8281: AND h.transactional_curr_code = p_curr_code
8282: AND (EXISTS

Line 8516: FROM oe_order_holds_ALL oh

8512: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
8513: AND h.transactional_curr_code = p_curr_code
8514: AND h.header_id <> l_header_id
8515: AND NOT EXISTS ( SELECT 1
8516: FROM oe_order_holds_ALL oh
8517: WHERE h.header_id = oh.header_id
8518: AND oh.line_id IS NULL
8519: AND oh.hold_release_id IS NULL )
8520: AND (EXISTS

Line 8569: FROM oe_order_holds_ALL oh

8565: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8566: AND h.transactional_curr_code = p_curr_code
8567: AND h.header_id <> l_header_id
8568: AND NOT EXISTS ( SELECT 1
8569: FROM oe_order_holds_ALL oh
8570: WHERE h.header_id = oh.header_id
8571: AND oh.line_id IS NULL
8572: AND oh.hold_release_id IS NULL )
8573: AND (EXISTS

Line 8621: FROM oe_order_holds_ALL oh

8617: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8618: AND h.transactional_curr_code = p_curr_code
8619: AND h.header_id <> l_header_id
8620: AND EXISTS ( SELECT 1
8621: FROM oe_order_holds_ALL oh
8622: WHERE h.header_id = oh.header_id
8623: AND oh.line_id IS NULL
8624: AND oh.hold_release_id IS NULL )
8625: AND (EXISTS

Line 8674: FROM oe_order_holds_ALL oh

8670: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8671: AND h.transactional_curr_code = p_curr_code
8672: AND h.header_id <> l_header_id
8673: AND EXISTS ( SELECT 1
8674: FROM oe_order_holds_ALL oh
8675: WHERE h.header_id = oh.header_id
8676: AND oh.line_id IS NULL
8677: AND oh.hold_release_id IS NULL )
8678: AND (EXISTS

Line 8718: FROM oe_order_holds_ALL oh

8714: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
8715: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8716: AND h.header_id <> l_header_id
8717: AND NOT EXISTS ( SELECT 1
8718: FROM oe_order_holds_ALL oh
8719: WHERE h.header_id = oh.header_id
8720: AND oh.line_id IS NULL
8721: AND oh.hold_release_id IS NULL )
8722: AND EXISTS

Line 8767: FROM oe_order_holds_ALL oh

8763: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
8764: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8765: AND h.header_id <> l_header_id
8766: AND NOT EXISTS ( SELECT 1
8767: FROM oe_order_holds_ALL oh
8768: WHERE h.header_id = oh.header_id
8769: AND oh.line_id IS NULL
8770: AND oh.hold_release_id IS NULL )
8771: AND EXISTS

Line 8814: FROM oe_order_holds_ALL oh

8810: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
8811: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8812: AND h.header_id <> l_header_id
8813: AND EXISTS ( SELECT 1
8814: FROM oe_order_holds_ALL oh
8815: WHERE h.header_id = oh.header_id
8816: AND oh.line_id IS NULL
8817: AND oh.hold_release_id IS NULL )
8818: AND EXISTS

Line 8862: FROM oe_order_holds_ALL oh

8858: AND ((p.list_line_type_code = 'FREIGHT_CHARGE' and p.applied_flag = 'Y') OR (p.list_line_type_code = 'TAX' and p.applied_flag = 'N' and p.parent_adjustment_id IS NOT NULL)) --TaxER --12895421
8859: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8860: AND h.header_id <> l_header_id
8861: AND EXISTS ( SELECT 1
8862: FROM oe_order_holds_ALL oh
8863: WHERE h.header_id = oh.header_id
8864: AND oh.line_id IS NULL
8865: AND oh.hold_release_id IS NULL )
8866: AND EXISTS