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 2417: FROM oe_payment_types_all pt,

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

Line 4412: FROM oe_payment_types_all pt

4408: AND l.line_category_code = 'ORDER'
4409: AND t.credit_check_flag = 'Y'
4410: AND (EXISTS
4411: (SELECT NULL
4412: FROM oe_payment_types_all pt
4413: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4414: NVL(h.payment_type_code, 'BME'))
4415: AND pt.credit_check_flag = 'Y'
4416: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4453: FROM oe_payment_types_all pt

4449: AND t.term_id = l.payment_term_id
4450: AND t.credit_check_flag = 'Y'
4451: AND (EXISTS
4452: (SELECT NULL
4453: FROM oe_payment_types_all pt
4454: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4455: NVL(h.payment_type_code, 'BME'))
4456: AND pt.credit_check_flag = 'Y'
4457: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4498: FROM oe_payment_types_all pt

4494: AND l.line_category_code = 'ORDER'
4495: AND p.header_id = h.header_id
4496: AND (EXISTS
4497: (SELECT NULL
4498: FROM oe_payment_types_all pt
4499: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4500: NVL(h.payment_type_code, 'BME'))
4501: AND pt.credit_check_flag = 'Y'
4502: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4565: FROM oe_payment_types_all pt

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

Line 4619: FROM oe_payment_types_all pt

4615: AND t.term_id = l.payment_term_id
4616: AND t.credit_check_flag = 'Y'
4617: AND (EXISTS
4618: (SELECT NULL
4619: FROM oe_payment_types_all pt
4620: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4621: NVL(h.payment_type_code, 'BME'))
4622: AND pt.credit_check_flag = 'Y'
4623: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4670: FROM oe_payment_types_all pt

4666: AND t.term_id = l.payment_term_id
4667: AND t.credit_check_flag = 'Y'
4668: AND (EXISTS
4669: (SELECT NULL
4670: FROM oe_payment_types_all pt
4671: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4672: NVL(h.payment_type_code, 'BME'))
4673: AND pt.credit_check_flag = 'Y'
4674: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4706: FROM oe_payment_types_all pt

4702: AND t.term_id = l.payment_term_id
4703: AND t.credit_check_flag = 'Y'
4704: AND (EXISTS
4705: (SELECT NULL
4706: FROM oe_payment_types_all pt
4707: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4708: NVL(h.payment_type_code, 'BME'))
4709: AND pt.credit_check_flag = 'Y'
4710: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4743: FROM oe_payment_types_all pt

4739: AND l.line_id = p.line_id
4740: AND p.header_id = h.header_id
4741: AND (EXISTS
4742: (SELECT NULL
4743: FROM oe_payment_types_all pt
4744: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4745: NVL(h.payment_type_code, 'BME'))
4746: AND pt.credit_check_flag = 'Y'
4747: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4807: FROM oe_payment_types_all pt

4803: AND t.term_id = l.payment_term_id
4804: AND t.credit_check_flag = 'Y'
4805: AND (EXISTS
4806: (SELECT NULL
4807: FROM oe_payment_types_all pt
4808: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4809: NVL(h.payment_type_code, 'BME'))
4810: AND pt.credit_check_flag = 'Y'
4811: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4858: FROM oe_payment_types_all pt

4854: AND t.term_id = l.payment_term_id
4855: AND t.credit_check_flag = 'Y'
4856: AND (EXISTS
4857: (SELECT NULL
4858: FROM oe_payment_types_all pt
4859: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4860: NVL(h.payment_type_code, 'BME'))
4861: AND pt.credit_check_flag = 'Y'
4862: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4910: FROM oe_payment_types_all pt

4906: AND t.term_id = l.payment_term_id
4907: AND t.credit_check_flag = 'Y'
4908: AND (EXISTS
4909: (SELECT NULL
4910: FROM oe_payment_types_all pt
4911: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4912: NVL(h.payment_type_code, 'BME'))
4913: AND pt.credit_check_flag = 'Y'
4914: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4945: FROM oe_payment_types_all pt

4941: AND t.term_id = l.payment_term_id
4942: AND t.credit_check_flag = 'Y'
4943: AND (EXISTS
4944: (SELECT NULL
4945: FROM oe_payment_types_all pt
4946: WHERE pt.payment_type_code = NVL(l.payment_type_code,
4947: NVL(h.payment_type_code, 'BME'))
4948: AND pt.credit_check_flag = 'Y'
4949: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 4988: FROM oe_payment_types_all pt

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

Line 5071: FROM oe_payment_types_all pt

5067: AND t.term_id = l.payment_term_id
5068: AND t.credit_check_flag = 'Y'
5069: AND (EXISTS
5070: (SELECT NULL
5071: FROM oe_payment_types_all pt
5072: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5073: NVL(h.payment_type_code,'BME'))
5074: AND pt.credit_check_flag = 'Y'
5075: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5139: FROM oe_payment_types_all pt

5135: AND t.term_id = l.payment_term_id
5136: AND t.credit_check_flag = 'Y'
5137: AND (EXISTS
5138: (SELECT NULL
5139: FROM oe_payment_types_all pt
5140: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5141: NVL(h.payment_type_code, 'BME'))
5142: AND pt.credit_check_flag = 'Y'
5143: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5848: FROM oe_payment_types_all pt

5844: AND h.header_id <> l_header_id
5845: AND h.transactional_curr_code = p_curr_code
5846: AND (EXISTS
5847: (SELECT NULL
5848: FROM oe_payment_types_all pt
5849: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5850: NVL(h.payment_type_code, 'BME'))
5851: AND pt.credit_check_flag = 'Y'
5852: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5886: FROM oe_payment_types_all pt

5882: AND h.header_id <> l_header_id
5883: AND h.transactional_curr_code = p_curr_code
5884: AND (EXISTS
5885: (SELECT NULL
5886: FROM oe_payment_types_all pt
5887: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5888: NVL(h.payment_type_code, 'BME'))
5889: AND pt.credit_check_flag = 'Y'
5890: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5923: FROM oe_payment_types_all pt

5919: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
5920: <= l_shipping_horizon
5921: AND (EXISTS
5922: (SELECT NULL
5923: FROM oe_payment_types_all pt
5924: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5925: NVL(h.payment_type_code, 'BME'))
5926: AND pt.credit_check_flag = 'Y'
5927: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5949: FROM oe_payment_types_all pt

5945: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
5946: <= l_shipping_horizon
5947: AND (EXISTS
5948: (SELECT NULL
5949: FROM oe_payment_types_all pt
5950: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5951: NVL(h.payment_type_code, 'BME'))
5952: AND pt.credit_check_flag = 'Y'
5953: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 5992: FROM oe_payment_types_all pt

5988: AND oh.hold_release_id IS NULL )
5989: AND h.transactional_curr_code = p_curr_code
5990: AND (EXISTS
5991: (SELECT NULL
5992: FROM oe_payment_types_all pt
5993: WHERE pt.payment_type_code = NVL(l.payment_type_code,
5994: NVL(h.payment_type_code, 'BME'))
5995: AND pt.credit_check_flag = 'Y'
5996: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6034: FROM oe_payment_types_all pt

6030: AND oh.hold_release_id IS NULL )
6031: AND h.transactional_curr_code = p_curr_code
6032: AND (EXISTS
6033: (SELECT NULL
6034: FROM oe_payment_types_all pt
6035: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6036: NVL(h.payment_type_code, 'BME'))
6037: AND pt.credit_check_flag = 'Y'
6038: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6074: FROM oe_payment_types_all pt

6070: AND oh.hold_release_id IS NULL )
6071: AND h.transactional_curr_code = p_curr_code
6072: AND (EXISTS
6073: (SELECT NULL
6074: FROM oe_payment_types_all pt
6075: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6076: NVL(h.payment_type_code, 'BME'))
6077: AND pt.credit_check_flag = 'Y'
6078: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6117: FROM oe_payment_types_all pt

6113: AND oh.hold_release_id IS NULL )
6114: AND h.transactional_curr_code = p_curr_code
6115: AND (EXISTS
6116: (SELECT NULL
6117: FROM oe_payment_types_all pt
6118: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6119: NVL(h.payment_type_code, 'BME'))
6120: AND pt.credit_check_flag = 'Y'
6121: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6164: FROM oe_payment_types_all pt

6160: AND h.transactional_curr_code = p_curr_code
6161: AND h.header_id <> l_header_id
6162: AND (EXISTS
6163: (SELECT NULL
6164: FROM oe_payment_types_all pt
6165: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6166: NVL(h.payment_type_code, 'BME'))
6167: AND pt.credit_check_flag = 'Y'
6168: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6209: FROM oe_payment_types_all pt

6205: AND h.transactional_curr_code = p_curr_code
6206: AND h.header_id <> l_header_id
6207: AND (EXISTS
6208: (SELECT NULL
6209: FROM oe_payment_types_all pt
6210: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6211: NVL(h.payment_type_code, 'BME'))
6212: AND pt.credit_check_flag = 'Y'
6213: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6246: FROM oe_payment_types_all pt,

6242: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6243: AND h.header_id <> l_header_id
6244: AND EXISTS
6245: (SELECT NULL
6246: FROM oe_payment_types_all pt,
6247: oe_order_lines l
6248: WHERE pt.credit_check_flag = 'Y'
6249: AND l.header_id = h.header_id
6250: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6289: FROM oe_payment_types_all pt,

6285: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6286: AND h.header_id <> l_header_id
6287: AND EXISTS
6288: (SELECT NULL
6289: FROM oe_payment_types_all pt,
6290: oe_order_lines l
6291: WHERE pt.credit_check_flag = 'Y'
6292: AND l.header_id = h.header_id
6293: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6344: FROM oe_payment_types_all pt

6340: AND oh.line_id IS NULL
6341: AND oh.hold_release_id IS NULL )
6342: AND (EXISTS
6343: (SELECT NULL
6344: FROM oe_payment_types_all pt
6345: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6346: NVL(h.payment_type_code, 'BME'))
6347: AND pt.credit_check_flag = 'Y'
6348: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6393: FROM oe_payment_types_all pt

6389: AND oh.line_id IS NULL
6390: AND oh.hold_release_id IS NULL )
6391: AND (EXISTS
6392: (SELECT NULL
6393: FROM oe_payment_types_all pt
6394: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6395: NVL(h.payment_type_code, 'BME'))
6396: AND pt.credit_check_flag = 'Y'
6397: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6443: FROM oe_payment_types_all pt

6439: AND oh.line_id IS NULL
6440: AND oh.hold_release_id IS NULL )
6441: AND (EXISTS
6442: (SELECT NULL
6443: FROM oe_payment_types_all pt
6444: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6445: NVL(h.payment_type_code, 'BME'))
6446: AND pt.credit_check_flag = 'Y'
6447: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6494: FROM oe_payment_types_all pt

6490: AND oh.line_id IS NULL
6491: AND oh.hold_release_id IS NULL )
6492: AND (EXISTS
6493: (SELECT NULL
6494: FROM oe_payment_types_all pt
6495: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6496: NVL(h.payment_type_code, 'BME'))
6497: AND pt.credit_check_flag = 'Y'
6498: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6533: FROM oe_payment_types_all pt,

6529: AND oh.line_id IS NULL
6530: AND oh.hold_release_id IS NULL )
6531: AND EXISTS
6532: (SELECT NULL
6533: FROM oe_payment_types_all pt,
6534: oe_order_lines_all l --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)
6535: WHERE pt.credit_check_flag = 'Y'
6536: AND l.header_id = h.header_id
6537: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6578: FROM oe_payment_types_all pt,

6574: AND oh.line_id IS NULL
6575: AND oh.hold_release_id IS NULL )
6576: AND EXISTS
6577: (SELECT NULL
6578: FROM oe_payment_types_all pt,
6579: oe_order_lines_all l --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)
6580: WHERE pt.credit_check_flag = 'Y'
6581: AND l.header_id = h.header_id
6582: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6622: FROM oe_payment_types_all pt,

6618: AND oh.line_id IS NULL
6619: AND oh.hold_release_id IS NULL )
6620: AND EXISTS
6621: (SELECT NULL
6622: FROM oe_payment_types_all pt,
6623: oe_order_lines_all l --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)
6624: WHERE pt.credit_check_flag = 'Y'
6625: AND l.header_id = h.header_id
6626: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6667: FROM oe_payment_types_all pt,

6663: AND oh.line_id IS NULL
6664: AND oh.hold_release_id IS NULL )
6665: AND EXISTS
6666: (SELECT NULL
6667: FROM oe_payment_types_all pt,
6668: oe_order_lines l
6669: WHERE pt.credit_check_flag = 'Y'
6670: AND l.header_id = h.header_id
6671: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 6807: FROM oe_payment_types_all pt

6803: AND h.header_id <> l_header_id
6804: AND h.transactional_curr_code = p_curr_code
6805: AND (EXISTS
6806: (SELECT NULL
6807: FROM oe_payment_types_all pt
6808: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6809: NVL(h.payment_type_code, 'BME'))
6810: AND pt.credit_check_flag = 'Y'
6811: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6842: FROM oe_payment_types_all pt

6838: AND h.header_id <> l_header_id
6839: AND h.transactional_curr_code = p_curr_code
6840: AND (EXISTS
6841: (SELECT NULL
6842: FROM oe_payment_types_all pt
6843: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6844: NVL(h.payment_type_code, 'BME'))
6845: AND pt.credit_check_flag = 'Y'
6846: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6879: FROM oe_payment_types_all pt

6875: AND oh.hold_release_id IS NULL )
6876: AND h.transactional_curr_code = p_curr_code
6877: AND (EXISTS
6878: (SELECT NULL
6879: FROM oe_payment_types_all pt
6880: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6881: NVL(h.payment_type_code, 'BME'))
6882: AND pt.credit_check_flag = 'Y'
6883: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6918: FROM oe_payment_types_all pt

6914: AND oh.hold_release_id IS NULL )
6915: AND h.transactional_curr_code = p_curr_code
6916: AND (EXISTS
6917: (SELECT NULL
6918: FROM oe_payment_types_all pt
6919: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6920: NVL(h.payment_type_code, 'BME'))
6921: AND pt.credit_check_flag = 'Y'
6922: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6953: FROM oe_payment_types_all pt

6949: AND oh.hold_release_id IS NULL )
6950: AND h.transactional_curr_code = p_curr_code
6951: AND (EXISTS
6952: (SELECT NULL
6953: FROM oe_payment_types_all pt
6954: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6955: NVL(h.payment_type_code, 'BME'))
6956: AND pt.credit_check_flag = 'Y'
6957: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 6989: FROM oe_payment_types_all pt

6985: AND oh.hold_release_id IS NULL )
6986: AND h.transactional_curr_code = p_curr_code
6987: AND (EXISTS
6988: (SELECT NULL
6989: FROM oe_payment_types_all pt
6990: WHERE pt.payment_type_code = NVL(l.payment_type_code,
6991: NVL(h.payment_type_code, 'BME'))
6992: AND pt.credit_check_flag = 'Y'
6993: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7028: FROM oe_payment_types_all pt

7024: AND h.transactional_curr_code = p_curr_code
7025: AND h.header_id <> l_header_id
7026: AND (EXISTS
7027: (SELECT NULL
7028: FROM oe_payment_types_all pt
7029: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7030: NVL(h.payment_type_code, 'BME'))
7031: AND pt.credit_check_flag = 'Y'
7032: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7069: FROM oe_payment_types_all pt

7065: AND h.transactional_curr_code = p_curr_code
7066: AND h.header_id <> l_header_id
7067: AND (EXISTS
7068: (SELECT NULL
7069: FROM oe_payment_types_all pt
7070: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7071: NVL(h.payment_type_code, 'BME'))
7072: AND pt.credit_check_flag = 'Y'
7073: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7098: FROM oe_payment_types_all pt,

7094: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7095: AND h.header_id <> l_header_id
7096: AND EXISTS
7097: (SELECT NULL
7098: FROM oe_payment_types_all pt,
7099: oe_order_lines l
7100: WHERE pt.credit_check_flag = 'Y'
7101: AND l.header_id = h.header_id
7102: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7133: FROM oe_payment_types_all pt,

7129: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7130: AND h.header_id <> l_header_id
7131: AND EXISTS
7132: (SELECT NULL
7133: FROM oe_payment_types_all pt,
7134: oe_order_lines l
7135: WHERE pt.credit_check_flag = 'Y'
7136: AND l.header_id = h.header_id
7137: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7182: FROM oe_payment_types_all pt

7178: AND oh.line_id IS NULL
7179: AND oh.hold_release_id IS NULL )
7180: AND (EXISTS
7181: (SELECT NULL
7182: FROM oe_payment_types_all pt
7183: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7184: NVL(h.payment_type_code, 'BME'))
7185: AND pt.credit_check_flag = 'Y'
7186: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7227: FROM oe_payment_types_all pt

7223: AND oh.line_id IS NULL
7224: AND oh.hold_release_id IS NULL )
7225: AND (EXISTS
7226: (SELECT NULL
7227: FROM oe_payment_types_all pt
7228: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7229: NVL(h.payment_type_code, 'BME'))
7230: AND pt.credit_check_flag = 'Y'
7231: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7271: FROM oe_payment_types_all pt

7267: AND oh.line_id IS NULL
7268: AND oh.hold_release_id IS NULL )
7269: AND (EXISTS
7270: (SELECT NULL
7271: FROM oe_payment_types_all pt
7272: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7273: NVL(h.payment_type_code, 'BME'))
7274: AND pt.credit_check_flag = 'Y'
7275: AND NVL(pt.org_id, -99) = G_ORG_ID)

Line 7315: FROM oe_payment_types_all pt,

7311: AND oh.line_id IS NULL
7312: AND oh.hold_release_id IS NULL )
7313: AND EXISTS
7314: (SELECT NULL
7315: FROM oe_payment_types_all pt,
7316: oe_order_lines l
7317: WHERE pt.credit_check_flag = 'Y'
7318: AND l.header_id = h.header_id
7319: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7355: FROM oe_payment_types_all pt,

7351: AND oh.line_id IS NULL
7352: AND oh.hold_release_id IS NULL )
7353: AND EXISTS
7354: (SELECT NULL
7355: FROM oe_payment_types_all pt,
7356: oe_order_lines l
7357: WHERE pt.credit_check_flag = 'Y'
7358: AND l.header_id = h.header_id
7359: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7396: FROM oe_payment_types_all pt,

7392: AND oh.line_id IS NULL
7393: AND oh.hold_release_id IS NULL )
7394: AND EXISTS
7395: (SELECT NULL
7396: FROM oe_payment_types_all pt,
7397: oe_order_lines l
7398: WHERE pt.credit_check_flag = 'Y'
7399: AND l.header_id = h.header_id
7400: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7436: FROM oe_payment_types_all pt,

7432: AND oh.line_id IS NULL
7433: AND oh.hold_release_id IS NULL )
7434: AND EXISTS
7435: (SELECT NULL
7436: FROM oe_payment_types_all pt,
7437: oe_order_lines l
7438: WHERE pt.credit_check_flag = 'Y'
7439: AND l.header_id = h.header_id
7440: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7476: FROM oe_payment_types_all pt,

7472: AND oh.line_id IS NULL
7473: AND oh.hold_release_id IS NULL )
7474: AND EXISTS
7475: (SELECT NULL
7476: FROM oe_payment_types_all pt,
7477: oe_order_lines l
7478: WHERE pt.credit_check_flag = 'Y'
7479: AND l.header_id = h.header_id
7480: AND l.org_id = pt.org_id /* MOAC_SQL_CHANGE */

Line 7736: FROM oe_payment_types_all pt

7732: AND h.header_id <> l_header_id
7733: AND h.transactional_curr_code = p_curr_code
7734: AND (EXISTS
7735: (SELECT NULL
7736: FROM oe_payment_types_all pt
7737: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7738: NVL(h.payment_type_code, 'BME'))
7739: AND pt.credit_check_flag = 'Y'
7740: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 7774: FROM oe_payment_types_all pt

7770: AND h.header_id <> l_header_id
7771: AND h.transactional_curr_code = p_curr_code
7772: AND (EXISTS
7773: (SELECT NULL
7774: FROM oe_payment_types_all pt
7775: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7776: NVL(h.payment_type_code, 'BME'))
7777: AND pt.credit_check_flag = 'Y'
7778: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 7814: FROM oe_payment_types_all pt

7810: AND NVL(L.SCHEDULE_SHIP_DATE,NVL(L.REQUEST_DATE,NVL(H.REQUEST_DATE,H.CREATION_DATE)))
7811: <= l_shipping_horizon
7812: AND (EXISTS
7813: (SELECT NULL
7814: FROM oe_payment_types_all pt
7815: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7816: NVL(h.payment_type_code, 'BME'))
7817: AND pt.credit_check_flag = 'Y'
7818: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 7856: FROM oe_payment_types_all pt

7852: AND oh.hold_release_id IS NULL )
7853: AND h.transactional_curr_code = p_curr_code
7854: AND (EXISTS
7855: (SELECT NULL
7856: FROM oe_payment_types_all pt
7857: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7858: NVL(h.payment_type_code, 'BME'))
7859: AND pt.credit_check_flag = 'Y'
7860: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 7898: FROM oe_payment_types_all pt

7894: AND oh.hold_release_id IS NULL )
7895: AND h.transactional_curr_code = p_curr_code
7896: AND (EXISTS
7897: (SELECT NULL
7898: FROM oe_payment_types_all pt
7899: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7900: NVL(h.payment_type_code, 'BME'))
7901: AND pt.credit_check_flag = 'Y'
7902: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 7938: FROM oe_payment_types_all pt

7934: AND oh.hold_release_id IS NULL )
7935: AND h.transactional_curr_code = p_curr_code
7936: AND (EXISTS
7937: (SELECT NULL
7938: FROM oe_payment_types_all pt
7939: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7940: NVL(h.payment_type_code, 'BME'))
7941: AND pt.credit_check_flag = 'Y'
7942: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 7979: FROM oe_payment_types_all pt

7975: AND oh.hold_release_id IS NULL )
7976: AND h.transactional_curr_code = p_curr_code
7977: AND (EXISTS
7978: (SELECT NULL
7979: FROM oe_payment_types_all pt
7980: WHERE pt.payment_type_code = NVL(l.payment_type_code,
7981: NVL(h.payment_type_code, 'BME'))
7982: AND pt.credit_check_flag = 'Y'
7983: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8024: FROM oe_payment_types_all pt

8020: AND h.transactional_curr_code = p_curr_code
8021: AND h.header_id <> l_header_id
8022: AND (EXISTS
8023: (SELECT NULL
8024: FROM oe_payment_types_all pt
8025: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8026: NVL(h.payment_type_code, 'BME'))
8027: AND pt.credit_check_flag = 'Y'
8028: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8069: FROM oe_payment_types_all pt

8065: AND h.transactional_curr_code = p_curr_code
8066: AND h.header_id <> l_header_id
8067: AND (EXISTS
8068: (SELECT NULL
8069: FROM oe_payment_types_all pt
8070: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8071: NVL(h.payment_type_code, 'BME'))
8072: AND pt.credit_check_flag = 'Y'
8073: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8105: FROM oe_payment_types_all t,

8101: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8102: AND h.header_id <> l_header_id
8103: AND EXISTS
8104: ( SELECT NULL
8105: FROM oe_payment_types_all t,
8106: oe_order_lines_all l
8107: WHERE t.credit_check_flag = 'Y'
8108: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8109: AND l.header_id = h.header_id

Line 8145: FROM oe_payment_types_all t,

8141: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8142: AND h.header_id <> l_header_id
8143: AND EXISTS
8144: ( SELECT NULL
8145: FROM oe_payment_types_all t,
8146: oe_order_lines_all l
8147: WHERE t.credit_check_flag = 'Y'
8148: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8149: AND l.header_id = h.header_id

Line 8197: FROM oe_payment_types_all pt

8193: AND oh.line_id IS NULL
8194: AND oh.hold_release_id IS NULL )
8195: AND (EXISTS
8196: (SELECT NULL
8197: FROM oe_payment_types_all pt
8198: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8199: NVL(h.payment_type_code, 'BME'))
8200: AND pt.credit_check_flag = 'Y'
8201: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8246: FROM oe_payment_types_all pt

8242: AND oh.line_id IS NULL
8243: AND oh.hold_release_id IS NULL )
8244: AND (EXISTS
8245: (SELECT NULL
8246: FROM oe_payment_types_all pt
8247: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8248: NVL(h.payment_type_code, 'BME'))
8249: AND pt.credit_check_flag = 'Y'
8250: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8294: FROM oe_payment_types_all pt

8290: AND oh.line_id IS NULL
8291: AND oh.hold_release_id IS NULL )
8292: AND (EXISTS
8293: (SELECT NULL
8294: FROM oe_payment_types_all pt
8295: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8296: NVL(h.payment_type_code, 'BME'))
8297: AND pt.credit_check_flag = 'Y'
8298: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8343: FROM oe_payment_types_all pt

8339: AND oh.line_id IS NULL
8340: AND oh.hold_release_id IS NULL )
8341: AND (EXISTS
8342: (SELECT NULL
8343: FROM oe_payment_types_all pt
8344: WHERE pt.payment_type_code = NVL(l.payment_type_code,
8345: NVL(h.payment_type_code, 'BME'))
8346: AND pt.credit_check_flag = 'Y'
8347: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 8383: FROM oe_payment_types_all t,

8379: AND oh.line_id IS NULL
8380: AND oh.hold_release_id IS NULL )
8381: AND EXISTS
8382: ( SELECT NULL
8383: FROM oe_payment_types_all t,
8384: oe_order_lines_all l
8385: WHERE t.credit_check_flag = 'Y'
8386: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8387: AND l.header_id = h.header_id

Line 8428: FROM oe_payment_types_all t,

8424: AND oh.line_id IS NULL
8425: AND oh.hold_release_id IS NULL )
8426: AND EXISTS
8427: ( SELECT NULL
8428: FROM oe_payment_types_all t,
8429: oe_order_lines_all l
8430: WHERE t.credit_check_flag = 'Y'
8431: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8432: AND l.header_id = h.header_id

Line 8471: FROM oe_payment_types_all t,

8467: AND oh.line_id IS NULL
8468: AND oh.hold_release_id IS NULL )
8469: AND EXISTS
8470: ( SELECT NULL
8471: FROM oe_payment_types_all t,
8472: oe_order_lines_all l
8473: WHERE t.credit_check_flag = 'Y'
8474: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8475: AND l.header_id = h.header_id

Line 8515: FROM oe_payment_types_all t,

8511: AND oh.line_id IS NULL
8512: AND oh.hold_release_id IS NULL )
8513: AND EXISTS
8514: ( SELECT NULL
8515: FROM oe_payment_types_all t,
8516: oe_order_lines_all l
8517: WHERE t.credit_check_flag = 'Y'
8518: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8519: AND l.header_id = h.header_id