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_PAYMENT_TYPES_ALL

Line 2418: FROM oe_payment_types_all pt,

2414: AND ln.line_category_code = 'ORDER'
2415: AND trm.credit_check_flag = 'Y'
2416: AND EXISTS
2417: (SELECT NULL
2418: FROM oe_payment_types_all pt,
2419: oe_order_headers_all h
2420: WHERE pt.credit_check_flag = 'Y'
2421: AND h.header_id = p_header_id
2422: AND ln.header_id = h.header_id

Line 4569: FROM oe_payment_types_all pt

4565: AND l.line_category_code = 'ORDER'
4566: AND t.credit_check_flag = 'Y'
4567: AND (EXISTS
4568: (SELECT NULL
4569: FROM oe_payment_types_all pt
4570: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4571: NVL(h.payment_type_code, 'BME'))
4572: AND pt.credit_check_flag = 'Y'
4573: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4611: FROM oe_payment_types_all pt

4607: AND t.term_id = l.payment_term_id
4608: AND t.credit_check_flag = 'Y'
4609: AND (EXISTS
4610: (SELECT NULL
4611: FROM oe_payment_types_all pt
4612: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4613: NVL(h.payment_type_code, 'BME'))
4614: AND pt.credit_check_flag = 'Y'
4615: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4657: FROM oe_payment_types_all pt

4653: AND l.line_category_code = 'ORDER'
4654: AND p.header_id = h.header_id
4655: AND (EXISTS
4656: (SELECT NULL
4657: FROM oe_payment_types_all pt
4658: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4659: NVL(h.payment_type_code, 'BME'))
4660: AND pt.credit_check_flag = 'Y'
4661: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4729: FROM oe_payment_types_all pt

4725: AND l.line_category_code = 'ORDER'
4726: AND t.credit_check_flag = 'Y'
4727: AND (EXISTS
4728: (SELECT NULL
4729: FROM oe_payment_types_all pt
4730: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4731: NVL(h.payment_type_code, 'BME'))
4732: AND pt.credit_check_flag = 'Y'
4733: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4788: FROM oe_payment_types_all pt

4784: AND t.term_id = l.payment_term_id
4785: AND t.credit_check_flag = 'Y'
4786: AND (EXISTS
4787: (SELECT NULL
4788: FROM oe_payment_types_all pt
4789: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4790: NVL(h.payment_type_code, 'BME'))
4791: AND pt.credit_check_flag = 'Y'
4792: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4840: FROM oe_payment_types_all pt

4836: AND t.term_id = l.payment_term_id
4837: AND t.credit_check_flag = 'Y'
4838: AND (EXISTS
4839: (SELECT NULL
4840: FROM oe_payment_types_all pt
4841: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4842: NVL(h.payment_type_code, 'BME'))
4843: AND pt.credit_check_flag = 'Y'
4844: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4877: FROM oe_payment_types_all pt

4873: AND t.term_id = l.payment_term_id
4874: AND t.credit_check_flag = 'Y'
4875: AND (EXISTS
4876: (SELECT NULL
4877: FROM oe_payment_types_all pt
4878: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4879: NVL(h.payment_type_code, 'BME'))
4880: AND pt.credit_check_flag = 'Y'
4881: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4915: FROM oe_payment_types_all pt

4911: AND l.line_id = p.line_id
4912: AND p.header_id = h.header_id
4913: AND (EXISTS
4914: (SELECT NULL
4915: FROM oe_payment_types_all pt
4916: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4917: NVL(h.payment_type_code, 'BME'))
4918: AND pt.credit_check_flag = 'Y'
4919: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4984: FROM oe_payment_types_all pt

4980: AND t.term_id = l.payment_term_id
4981: AND t.credit_check_flag = 'Y'
4982: AND (EXISTS
4983: (SELECT NULL
4984: FROM oe_payment_types_all pt
4985: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4986: NVL(h.payment_type_code, 'BME'))
4987: AND pt.credit_check_flag = 'Y'
4988: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5040: FROM oe_payment_types_all pt

5036: AND t.term_id = l.payment_term_id
5037: AND t.credit_check_flag = 'Y'
5038: AND (EXISTS
5039: (SELECT NULL
5040: FROM oe_payment_types_all pt
5041: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5042: NVL(h.payment_type_code, 'BME'))
5043: AND pt.credit_check_flag = 'Y'
5044: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5093: FROM oe_payment_types_all pt

5089: AND t.term_id = l.payment_term_id
5090: AND t.credit_check_flag = 'Y'
5091: AND (EXISTS
5092: (SELECT NULL
5093: FROM oe_payment_types_all pt
5094: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5095: NVL(h.payment_type_code, 'BME'))
5096: AND pt.credit_check_flag = 'Y'
5097: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5129: FROM oe_payment_types_all pt

5125: AND t.term_id = l.payment_term_id
5126: AND t.credit_check_flag = 'Y'
5127: AND (EXISTS
5128: (SELECT NULL
5129: FROM oe_payment_types_all pt
5130: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5131: NVL(h.payment_type_code, 'BME'))
5132: AND pt.credit_check_flag = 'Y'
5133: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5173: FROM oe_payment_types_all pt

5169: AND t.term_id = l.payment_term_id
5170: AND t.credit_check_flag = 'Y'
5171: AND (EXISTS
5172: (SELECT NULL
5173: FROM oe_payment_types_all pt
5174: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5175: NVL(h.payment_type_code,'BME'))
5176: AND pt.credit_check_flag = 'Y'
5177: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5261: FROM oe_payment_types_all pt

5257: AND t.term_id = l.payment_term_id
5258: AND t.credit_check_flag = 'Y'
5259: AND (EXISTS
5260: (SELECT NULL
5261: FROM oe_payment_types_all pt
5262: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5263: NVL(h.payment_type_code,'BME'))
5264: AND pt.credit_check_flag = 'Y'
5265: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5338: FROM oe_payment_types_all pt

5334: AND t.term_id = l.payment_term_id
5335: AND t.credit_check_flag = 'Y'
5336: AND (EXISTS
5337: (SELECT NULL
5338: FROM oe_payment_types_all pt
5339: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5340: NVL(h.payment_type_code, 'BME'))
5341: AND pt.credit_check_flag = 'Y'
5342: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6056: FROM oe_payment_types_all pt

6052: AND h.header_id <> l_header_id
6053: AND h.transactional_curr_code = p_curr_code
6054: AND (EXISTS
6055: (SELECT NULL
6056: FROM oe_payment_types_all pt
6057: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6058: NVL(h.payment_type_code, 'BME'))
6059: AND pt.credit_check_flag = 'Y'
6060: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6094: FROM oe_payment_types_all pt

6090: AND h.header_id <> l_header_id
6091: AND h.transactional_curr_code = p_curr_code
6092: AND (EXISTS
6093: (SELECT NULL
6094: FROM oe_payment_types_all pt
6095: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6096: NVL(h.payment_type_code, 'BME'))
6097: AND pt.credit_check_flag = 'Y'
6098: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6131: FROM oe_payment_types_all pt

6127: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6128: <= l_shipping_horizon
6129: AND (EXISTS
6130: (SELECT NULL
6131: FROM oe_payment_types_all pt
6132: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6133: NVL(h.payment_type_code, 'BME'))
6134: AND pt.credit_check_flag = 'Y'
6135: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6157: FROM oe_payment_types_all pt

6153: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
6154: <= l_shipping_horizon
6155: AND (EXISTS
6156: (SELECT NULL
6157: FROM oe_payment_types_all pt
6158: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6159: NVL(h.payment_type_code, 'BME'))
6160: AND pt.credit_check_flag = 'Y'
6161: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6200: FROM oe_payment_types_all pt

6196: AND oh.hold_release_id IS NULL )
6197: AND h.transactional_curr_code = p_curr_code
6198: AND (EXISTS
6199: (SELECT NULL
6200: FROM oe_payment_types_all pt
6201: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6202: NVL(h.payment_type_code, 'BME'))
6203: AND pt.credit_check_flag = 'Y'
6204: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6242: FROM oe_payment_types_all pt

6238: AND oh.hold_release_id IS NULL )
6239: AND h.transactional_curr_code = p_curr_code
6240: AND (EXISTS
6241: (SELECT NULL
6242: FROM oe_payment_types_all pt
6243: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6244: NVL(h.payment_type_code, 'BME'))
6245: AND pt.credit_check_flag = 'Y'
6246: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6282: FROM oe_payment_types_all pt

6278: AND oh.hold_release_id IS NULL )
6279: AND h.transactional_curr_code = p_curr_code
6280: AND (EXISTS
6281: (SELECT NULL
6282: FROM oe_payment_types_all pt
6283: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6284: NVL(h.payment_type_code, 'BME'))
6285: AND pt.credit_check_flag = 'Y'
6286: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6325: FROM oe_payment_types_all pt

6321: AND oh.hold_release_id IS NULL )
6322: AND h.transactional_curr_code = p_curr_code
6323: AND (EXISTS
6324: (SELECT NULL
6325: FROM oe_payment_types_all pt
6326: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6327: NVL(h.payment_type_code, 'BME'))
6328: AND pt.credit_check_flag = 'Y'
6329: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6376: FROM oe_payment_types_all pt

6372: AND h.transactional_curr_code = p_curr_code
6373: AND h.header_id <> l_header_id
6374: AND (EXISTS
6375: (SELECT NULL
6376: FROM oe_payment_types_all pt
6377: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6378: NVL(h.payment_type_code, 'BME'))
6379: AND pt.credit_check_flag = 'Y'
6380: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6425: FROM oe_payment_types_all pt

6421: AND h.transactional_curr_code = p_curr_code
6422: AND h.header_id <> l_header_id
6423: AND (EXISTS
6424: (SELECT NULL
6425: FROM oe_payment_types_all pt
6426: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6427: NVL(h.payment_type_code, 'BME'))
6428: AND pt.credit_check_flag = 'Y'
6429: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6466: FROM oe_payment_types_all pt,

6462: 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
6463: AND h.header_id <> l_header_id
6464: AND EXISTS
6465: (SELECT NULL
6466: FROM oe_payment_types_all pt,
6467: oe_order_lines l
6468: WHERE pt.credit_check_flag = 'Y'
6469: AND l.header_id = h.header_id
6470: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6513: FROM oe_payment_types_all pt,

6509: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6510: AND h.header_id <> l_header_id
6511: AND EXISTS
6512: (SELECT NULL
6513: FROM oe_payment_types_all pt,
6514: oe_order_lines l
6515: WHERE pt.credit_check_flag = 'Y'
6516: AND l.header_id = h.header_id
6517: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6572: FROM oe_payment_types_all pt

6568: AND oh.line_id IS NULL
6569: AND oh.hold_release_id IS NULL )
6570: AND (EXISTS
6571: (SELECT NULL
6572: FROM oe_payment_types_all pt
6573: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6574: NVL(h.payment_type_code, 'BME'))
6575: AND pt.credit_check_flag = 'Y'
6576: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6625: FROM oe_payment_types_all pt

6621: AND oh.line_id IS NULL
6622: AND oh.hold_release_id IS NULL )
6623: AND (EXISTS
6624: (SELECT NULL
6625: FROM oe_payment_types_all pt
6626: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6627: NVL(h.payment_type_code, 'BME'))
6628: AND pt.credit_check_flag = 'Y'
6629: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6679: FROM oe_payment_types_all pt

6675: AND oh.line_id IS NULL
6676: AND oh.hold_release_id IS NULL )
6677: AND (EXISTS
6678: (SELECT NULL
6679: FROM oe_payment_types_all pt
6680: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6681: NVL(h.payment_type_code, 'BME'))
6682: AND pt.credit_check_flag = 'Y'
6683: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6734: FROM oe_payment_types_all pt

6730: AND oh.line_id IS NULL
6731: AND oh.hold_release_id IS NULL )
6732: AND (EXISTS
6733: (SELECT NULL
6734: FROM oe_payment_types_all pt
6735: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6736: NVL(h.payment_type_code, 'BME'))
6737: AND pt.credit_check_flag = 'Y'
6738: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6777: FROM oe_payment_types_all pt,

6773: AND oh.line_id IS NULL
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 */

Line 6826: FROM oe_payment_types_all pt,

6822: AND oh.line_id IS NULL
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 */

Line 6874: FROM oe_payment_types_all pt,

6870: AND oh.line_id IS NULL
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 */

Line 6923: FROM oe_payment_types_all pt,

6919: AND oh.line_id IS NULL
6920: AND oh.hold_release_id IS NULL )
6921: AND EXISTS
6922: (SELECT NULL
6923: FROM oe_payment_types_all pt,
6924: oe_order_lines l
6925: WHERE pt.credit_check_flag = 'Y'
6926: AND l.header_id = h.header_id
6927: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7063: FROM oe_payment_types_all pt

7059: AND h.header_id <> l_header_id
7060: AND h.transactional_curr_code = p_curr_code
7061: AND (EXISTS
7062: (SELECT NULL
7063: FROM oe_payment_types_all pt
7064: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7065: NVL(h.payment_type_code, 'BME'))
7066: AND pt.credit_check_flag = 'Y'
7067: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7098: FROM oe_payment_types_all pt

7094: AND h.header_id <> l_header_id
7095: AND h.transactional_curr_code = p_curr_code
7096: AND (EXISTS
7097: (SELECT NULL
7098: FROM oe_payment_types_all pt
7099: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7100: NVL(h.payment_type_code, 'BME'))
7101: AND pt.credit_check_flag = 'Y'
7102: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7135: FROM oe_payment_types_all pt

7131: AND oh.hold_release_id IS NULL )
7132: AND h.transactional_curr_code = p_curr_code
7133: AND (EXISTS
7134: (SELECT NULL
7135: FROM oe_payment_types_all pt
7136: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7137: NVL(h.payment_type_code, 'BME'))
7138: AND pt.credit_check_flag = 'Y'
7139: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7174: FROM oe_payment_types_all pt

7170: AND oh.hold_release_id IS NULL )
7171: AND h.transactional_curr_code = p_curr_code
7172: AND (EXISTS
7173: (SELECT NULL
7174: FROM oe_payment_types_all pt
7175: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7176: NVL(h.payment_type_code, 'BME'))
7177: AND pt.credit_check_flag = 'Y'
7178: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7209: FROM oe_payment_types_all pt

7205: AND oh.hold_release_id IS NULL )
7206: AND h.transactional_curr_code = p_curr_code
7207: AND (EXISTS
7208: (SELECT NULL
7209: FROM oe_payment_types_all pt
7210: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7211: NVL(h.payment_type_code, 'BME'))
7212: AND pt.credit_check_flag = 'Y'
7213: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7245: FROM oe_payment_types_all pt

7241: AND oh.hold_release_id IS NULL )
7242: AND h.transactional_curr_code = p_curr_code
7243: AND (EXISTS
7244: (SELECT NULL
7245: FROM oe_payment_types_all pt
7246: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7247: NVL(h.payment_type_code, 'BME'))
7248: AND pt.credit_check_flag = 'Y'
7249: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7288: FROM oe_payment_types_all pt

7284: AND h.transactional_curr_code = p_curr_code
7285: AND h.header_id <> l_header_id
7286: AND (EXISTS
7287: (SELECT NULL
7288: FROM oe_payment_types_all pt
7289: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7290: NVL(h.payment_type_code, 'BME'))
7291: AND pt.credit_check_flag = 'Y'
7292: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7333: FROM oe_payment_types_all pt

7329: AND h.transactional_curr_code = p_curr_code
7330: AND h.header_id <> l_header_id
7331: AND (EXISTS
7332: (SELECT NULL
7333: FROM oe_payment_types_all pt
7334: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7335: NVL(h.payment_type_code, 'BME'))
7336: AND pt.credit_check_flag = 'Y'
7337: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7366: FROM oe_payment_types_all pt,

7362: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7363: AND h.header_id <> l_header_id
7364: AND EXISTS
7365: (SELECT NULL
7366: FROM oe_payment_types_all pt,
7367: oe_order_lines l
7368: WHERE pt.credit_check_flag = 'Y'
7369: AND l.header_id = h.header_id
7370: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7405: FROM oe_payment_types_all pt,

7401: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7402: AND h.header_id <> l_header_id
7403: AND EXISTS
7404: (SELECT NULL
7405: FROM oe_payment_types_all pt,
7406: oe_order_lines l
7407: WHERE pt.credit_check_flag = 'Y'
7408: AND l.header_id = h.header_id
7409: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7458: FROM oe_payment_types_all pt

7454: AND oh.line_id IS NULL
7455: AND oh.hold_release_id IS NULL )
7456: AND (EXISTS
7457: (SELECT NULL
7458: FROM oe_payment_types_all pt
7459: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7460: NVL(h.payment_type_code, 'BME'))
7461: AND pt.credit_check_flag = 'Y'
7462: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7507: FROM oe_payment_types_all pt

7503: AND oh.line_id IS NULL
7504: AND oh.hold_release_id IS NULL )
7505: AND (EXISTS
7506: (SELECT NULL
7507: FROM oe_payment_types_all pt
7508: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7509: NVL(h.payment_type_code, 'BME'))
7510: AND pt.credit_check_flag = 'Y'
7511: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7555: FROM oe_payment_types_all pt

7551: AND oh.line_id IS NULL
7552: AND oh.hold_release_id IS NULL )
7553: AND (EXISTS
7554: (SELECT NULL
7555: FROM oe_payment_types_all pt
7556: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7557: NVL(h.payment_type_code, 'BME'))
7558: AND pt.credit_check_flag = 'Y'
7559: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7603: FROM oe_payment_types_all pt,

7599: AND oh.line_id IS NULL
7600: AND oh.hold_release_id IS NULL )
7601: AND EXISTS
7602: (SELECT NULL
7603: FROM oe_payment_types_all pt,
7604: oe_order_lines l
7605: WHERE pt.credit_check_flag = 'Y'
7606: AND l.header_id = h.header_id
7607: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7647: FROM oe_payment_types_all pt,

7643: AND oh.line_id IS NULL
7644: AND oh.hold_release_id IS NULL )
7645: AND EXISTS
7646: (SELECT NULL
7647: FROM oe_payment_types_all pt,
7648: oe_order_lines l
7649: WHERE pt.credit_check_flag = 'Y'
7650: AND l.header_id = h.header_id
7651: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7692: FROM oe_payment_types_all pt,

7688: AND oh.line_id IS NULL
7689: AND oh.hold_release_id IS NULL )
7690: AND EXISTS
7691: (SELECT NULL
7692: FROM oe_payment_types_all pt,
7693: oe_order_lines l
7694: WHERE pt.credit_check_flag = 'Y'
7695: AND l.header_id = h.header_id
7696: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7736: FROM oe_payment_types_all pt,

7732: AND oh.line_id IS NULL
7733: AND oh.hold_release_id IS NULL )
7734: AND EXISTS
7735: (SELECT NULL
7736: FROM oe_payment_types_all pt,
7737: oe_order_lines l
7738: WHERE pt.credit_check_flag = 'Y'
7739: AND l.header_id = h.header_id
7740: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7780: FROM oe_payment_types_all pt,

7776: AND oh.line_id IS NULL
7777: AND oh.hold_release_id IS NULL )
7778: AND EXISTS
7779: (SELECT NULL
7780: FROM oe_payment_types_all pt,
7781: oe_order_lines l
7782: WHERE pt.credit_check_flag = 'Y'
7783: AND l.header_id = h.header_id
7784: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 8041: FROM oe_payment_types_all pt

8037: AND h.header_id <> l_header_id
8038: AND h.transactional_curr_code = p_curr_code
8039: AND (EXISTS
8040: (SELECT NULL
8041: FROM oe_payment_types_all pt
8042: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8043: NVL(h.payment_type_code, 'BME'))
8044: AND pt.credit_check_flag = 'Y'
8045: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8079: FROM oe_payment_types_all pt

8075: AND h.header_id <> l_header_id
8076: AND h.transactional_curr_code = p_curr_code
8077: AND (EXISTS
8078: (SELECT NULL
8079: FROM oe_payment_types_all pt
8080: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8081: NVL(h.payment_type_code, 'BME'))
8082: AND pt.credit_check_flag = 'Y'
8083: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8119: FROM oe_payment_types_all pt

8115: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
8116: <= l_shipping_horizon
8117: AND (EXISTS
8118: (SELECT NULL
8119: FROM oe_payment_types_all pt
8120: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8121: NVL(h.payment_type_code, 'BME'))
8122: AND pt.credit_check_flag = 'Y'
8123: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8161: FROM oe_payment_types_all pt

8157: AND oh.hold_release_id IS NULL )
8158: AND h.transactional_curr_code = p_curr_code
8159: AND (EXISTS
8160: (SELECT NULL
8161: FROM oe_payment_types_all pt
8162: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8163: NVL(h.payment_type_code, 'BME'))
8164: AND pt.credit_check_flag = 'Y'
8165: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8203: FROM oe_payment_types_all pt

8199: AND oh.hold_release_id IS NULL )
8200: AND h.transactional_curr_code = p_curr_code
8201: AND (EXISTS
8202: (SELECT NULL
8203: FROM oe_payment_types_all pt
8204: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8205: NVL(h.payment_type_code, 'BME'))
8206: AND pt.credit_check_flag = 'Y'
8207: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8243: FROM oe_payment_types_all pt

8239: AND oh.hold_release_id IS NULL )
8240: AND h.transactional_curr_code = p_curr_code
8241: AND (EXISTS
8242: (SELECT NULL
8243: FROM oe_payment_types_all pt
8244: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8245: NVL(h.payment_type_code, 'BME'))
8246: AND pt.credit_check_flag = 'Y'
8247: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8284: FROM oe_payment_types_all pt

8280: AND oh.hold_release_id IS NULL )
8281: AND h.transactional_curr_code = p_curr_code
8282: AND (EXISTS
8283: (SELECT NULL
8284: FROM oe_payment_types_all pt
8285: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8286: NVL(h.payment_type_code, 'BME'))
8287: AND pt.credit_check_flag = 'Y'
8288: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8333: FROM oe_payment_types_all pt

8329: AND h.transactional_curr_code = p_curr_code
8330: AND h.header_id <> l_header_id
8331: AND (EXISTS
8332: (SELECT NULL
8333: FROM oe_payment_types_all pt
8334: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8335: NVL(h.payment_type_code, 'BME'))
8336: AND pt.credit_check_flag = 'Y'
8337: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8382: FROM oe_payment_types_all pt

8378: AND h.transactional_curr_code = p_curr_code
8379: AND h.header_id <> l_header_id
8380: AND (EXISTS
8381: (SELECT NULL
8382: FROM oe_payment_types_all pt
8383: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8384: NVL(h.payment_type_code, 'BME'))
8385: AND pt.credit_check_flag = 'Y'
8386: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8422: FROM oe_payment_types_all t,

8418: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8419: AND h.header_id <> l_header_id
8420: AND EXISTS
8421: ( SELECT NULL
8422: FROM oe_payment_types_all t,
8423: oe_order_lines_all l
8424: WHERE t.credit_check_flag = 'Y'
8425: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8426: AND l.header_id = h.header_id

Line 8466: FROM oe_payment_types_all t,

8462: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8463: AND h.header_id <> l_header_id
8464: AND EXISTS
8465: ( SELECT NULL
8466: FROM oe_payment_types_all t,
8467: oe_order_lines_all l
8468: WHERE t.credit_check_flag = 'Y'
8469: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8470: AND l.header_id = h.header_id

Line 8522: FROM oe_payment_types_all pt

8518: AND oh.line_id IS NULL
8519: AND oh.hold_release_id IS NULL )
8520: AND (EXISTS
8521: (SELECT NULL
8522: FROM oe_payment_types_all pt
8523: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8524: NVL(h.payment_type_code, 'BME'))
8525: AND pt.credit_check_flag = 'Y'
8526: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8575: FROM oe_payment_types_all pt

8571: AND oh.line_id IS NULL
8572: AND oh.hold_release_id IS NULL )
8573: AND (EXISTS
8574: (SELECT NULL
8575: FROM oe_payment_types_all pt
8576: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8577: NVL(h.payment_type_code, 'BME'))
8578: AND pt.credit_check_flag = 'Y'
8579: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8627: FROM oe_payment_types_all pt

8623: AND oh.line_id IS NULL
8624: AND oh.hold_release_id IS NULL )
8625: AND (EXISTS
8626: (SELECT NULL
8627: FROM oe_payment_types_all pt
8628: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8629: NVL(h.payment_type_code, 'BME'))
8630: AND pt.credit_check_flag = 'Y'
8631: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8680: FROM oe_payment_types_all pt

8676: AND oh.line_id IS NULL
8677: AND oh.hold_release_id IS NULL )
8678: AND (EXISTS
8679: (SELECT NULL
8680: FROM oe_payment_types_all pt
8681: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8682: NVL(h.payment_type_code, 'BME'))
8683: AND pt.credit_check_flag = 'Y'
8684: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8724: FROM oe_payment_types_all t,

8720: AND oh.line_id IS NULL
8721: AND oh.hold_release_id IS NULL )
8722: AND EXISTS
8723: ( SELECT NULL
8724: FROM oe_payment_types_all t,
8725: oe_order_lines_all l
8726: WHERE t.credit_check_flag = 'Y'
8727: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8728: AND l.header_id = h.header_id

Line 8773: FROM oe_payment_types_all t,

8769: AND oh.line_id IS NULL
8770: AND oh.hold_release_id IS NULL )
8771: AND EXISTS
8772: ( SELECT NULL
8773: FROM oe_payment_types_all t,
8774: oe_order_lines_all l
8775: WHERE t.credit_check_flag = 'Y'
8776: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8777: AND l.header_id = h.header_id

Line 8820: FROM oe_payment_types_all t,

8816: AND oh.line_id IS NULL
8817: AND oh.hold_release_id IS NULL )
8818: AND EXISTS
8819: ( SELECT NULL
8820: FROM oe_payment_types_all t,
8821: oe_order_lines_all l
8822: WHERE t.credit_check_flag = 'Y'
8823: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8824: AND l.header_id = h.header_id

Line 8868: FROM oe_payment_types_all t,

8864: AND oh.line_id IS NULL
8865: AND oh.hold_release_id IS NULL )
8866: AND EXISTS
8867: ( SELECT NULL
8868: FROM oe_payment_types_all t,
8869: oe_order_lines_all l
8870: WHERE t.credit_check_flag = 'Y'
8871: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8872: AND l.header_id = h.header_id