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 5986: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880589 FTS on OE_ORDER_HOLDS_ALL)

5982: AND h.booked_flag = 'Y'
5983: AND l.open_flag = 'Y'
5984: AND h.header_id <> l_header_id
5985: AND NOT EXISTS ( SELECT 1
5986: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880589 FTS on OE_ORDER_HOLDS_ALL)
5987: WHERE h.header_id = oh.header_id
5988: AND oh.hold_release_id IS NULL )
5989: AND h.transactional_curr_code = p_curr_code
5990: AND (EXISTS

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

6024: AND h.booked_flag = 'Y'
6025: AND l.open_flag = 'Y'
6026: AND h.header_id <> l_header_id
6027: AND NOT EXISTS ( SELECT 1
6028: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880618 FTS on OE_ORDER_HOLDS_ALL)
6029: WHERE h.header_id = oh.header_id
6030: AND oh.hold_release_id IS NULL )
6031: AND h.transactional_curr_code = p_curr_code
6032: AND (EXISTS

Line 6068: FROM oe_order_holds_all oh

6064: AND h.booked_flag = 'Y'
6065: AND l.open_flag = 'Y'
6066: AND h.header_id <> l_header_id
6067: AND EXISTS ( SELECT 1
6068: FROM oe_order_holds_all oh
6069: WHERE h.header_id = oh.header_id
6070: AND oh.hold_release_id IS NULL )
6071: AND h.transactional_curr_code = p_curr_code
6072: AND (EXISTS

Line 6111: FROM oe_order_holds_all oh

6107: AND h.booked_flag = 'Y'
6108: AND l.open_flag = 'Y'
6109: AND h.header_id <> l_header_id
6110: AND EXISTS ( SELECT 1
6111: FROM oe_order_holds_all oh
6112: WHERE h.header_id = oh.header_id
6113: AND oh.hold_release_id IS NULL )
6114: AND h.transactional_curr_code = p_curr_code
6115: AND (EXISTS

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

6334: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6335: AND h.transactional_curr_code = p_curr_code
6336: AND h.header_id <> l_header_id
6337: AND NOT EXISTS ( SELECT 1
6338: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880775 FTS on OE_ORDER_HOLDS_ALL)
6339: WHERE h.header_id = oh.header_id
6340: AND oh.line_id IS NULL
6341: AND oh.hold_release_id IS NULL )
6342: AND (EXISTS

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

6383: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6384: AND h.transactional_curr_code = p_curr_code
6385: AND h.header_id <> l_header_id
6386: AND NOT EXISTS ( SELECT 1
6387: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880801 FTS on OE_ORDER_HOLDS_ALL)
6388: WHERE h.header_id = oh.header_id
6389: AND oh.line_id IS NULL
6390: AND oh.hold_release_id IS NULL )
6391: AND (EXISTS

Line 6437: FROM oe_order_holds_all oh

6433: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6434: AND h.transactional_curr_code = p_curr_code
6435: AND h.header_id <> l_header_id
6436: AND EXISTS ( SELECT 1
6437: FROM oe_order_holds_all oh
6438: WHERE h.header_id = oh.header_id
6439: AND oh.line_id IS NULL
6440: AND oh.hold_release_id IS NULL )
6441: AND (EXISTS

Line 6488: FROM oe_order_holds_all oh

6484: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6485: AND h.transactional_curr_code = p_curr_code
6486: AND h.header_id <> l_header_id
6487: AND EXISTS ( SELECT 1
6488: FROM oe_order_holds_all oh
6489: WHERE h.header_id = oh.header_id
6490: AND oh.line_id IS NULL
6491: AND oh.hold_release_id IS NULL )
6492: AND (EXISTS

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

6523: AND p.list_line_type_code = 'FREIGHT_CHARGE'
6524: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6525: AND h.header_id <> l_header_id
6526: AND NOT EXISTS ( SELECT 1
6527: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880869 FTS on OE_ORDER_HOLDS_ALL)
6528: WHERE h.header_id = oh.header_id
6529: AND oh.line_id IS NULL
6530: AND oh.hold_release_id IS NULL )
6531: AND EXISTS

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

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 */
6538: AND NVL(pt.org_id, -99) = G_ORG_ID

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

6568: AND p.list_line_type_code = 'FREIGHT_CHARGE'
6569: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6570: AND h.header_id <> l_header_id
6571: AND NOT EXISTS ( SELECT 1
6572: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880892 FTS on OE_ORDER_HOLDS_ALL)
6573: WHERE h.header_id = oh.header_id
6574: AND oh.line_id IS NULL
6575: AND oh.hold_release_id IS NULL )
6576: AND EXISTS

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

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 */
6583: AND NVL(pt.org_id, -99) = G_ORG_ID

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

6612: AND p.list_line_type_code = 'FREIGHT_CHARGE'
6613: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6614: AND h.header_id <> l_header_id
6615: AND EXISTS ( SELECT 1
6616: FROM oe_order_holds_all oh --Performance issue (SQL ID-14880915 FTS on OE_ORDER_HOLDS_ALL)
6617: WHERE h.header_id = oh.header_id
6618: AND oh.line_id IS NULL
6619: AND oh.hold_release_id IS NULL )
6620: AND EXISTS

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

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 */
6627: AND NVL(pt.org_id, -99) = G_ORG_ID

Line 6661: FROM oe_order_holds_all oh

6657: AND p.list_line_type_code = 'FREIGHT_CHARGE'
6658: AND ( p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
6659: AND h.header_id <> l_header_id
6660: AND EXISTS ( SELECT 1
6661: FROM oe_order_holds_all oh
6662: WHERE h.header_id = oh.header_id
6663: AND oh.line_id IS NULL
6664: AND oh.hold_release_id IS NULL )
6665: AND EXISTS

Line 6873: FROM oe_order_holds_all oh

6869: AND h.booked_flag = 'Y'
6870: AND l.open_flag = 'Y'
6871: AND h.header_id <> l_header_id
6872: AND NOT EXISTS ( SELECT 1
6873: FROM oe_order_holds_all oh
6874: WHERE h.header_id = oh.header_id
6875: AND oh.hold_release_id IS NULL )
6876: AND h.transactional_curr_code = p_curr_code
6877: AND (EXISTS

Line 6912: FROM oe_order_holds_all oh

6908: AND h.booked_flag = 'Y'
6909: AND l.open_flag = 'Y'
6910: AND h.header_id <> l_header_id
6911: AND NOT EXISTS ( SELECT 1
6912: FROM oe_order_holds_all oh
6913: WHERE h.header_id = oh.header_id
6914: AND oh.hold_release_id IS NULL )
6915: AND h.transactional_curr_code = p_curr_code
6916: AND (EXISTS

Line 6947: FROM oe_order_holds_all oh

6943: AND h.booked_flag = 'Y'
6944: AND l.open_flag = 'Y'
6945: AND h.header_id <> l_header_id
6946: AND EXISTS ( SELECT 1
6947: FROM oe_order_holds_all oh
6948: WHERE h.header_id = oh.header_id
6949: AND oh.hold_release_id IS NULL )
6950: AND h.transactional_curr_code = p_curr_code
6951: AND (EXISTS

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

6979: AND h.booked_flag = 'Y'
6980: AND l.open_flag = 'Y'
6981: AND h.header_id <> l_header_id
6982: AND EXISTS ( SELECT 1
6983: FROM oe_order_holds_all oh --Performance issue (SQL ID-14881132 FTS on OE_ORDER_HOLDS_ALL)
6984: WHERE h.header_id = oh.header_id
6985: AND oh.hold_release_id IS NULL )
6986: AND h.transactional_curr_code = p_curr_code
6987: AND (EXISTS

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

7172: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7173: AND h.transactional_curr_code = p_curr_code
7174: AND h.header_id <> l_header_id
7175: AND NOT EXISTS ( SELECT 1
7176: FROM oe_order_holds_all oh --Modified the query to access oe_order_holds_all
7177: WHERE h.header_id = oh.header_id --instead of oe_order_holds to avoid FTS (SQL ID#14881276)
7178: AND oh.line_id IS NULL
7179: AND oh.hold_release_id IS NULL )
7180: AND (EXISTS

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

7217: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7218: AND h.transactional_curr_code = p_curr_code
7219: AND h.header_id <> l_header_id
7220: AND NOT EXISTS ( SELECT 1
7221: FROM oe_order_holds_all oh --Modified the query to select from
7222: WHERE h.header_id = oh.header_id --oe_order_holds_all to avoid FTS (SQL#14881293)
7223: AND oh.line_id IS NULL
7224: AND oh.hold_release_id IS NULL )
7225: AND (EXISTS

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

7218: AND h.transactional_curr_code = p_curr_code
7219: AND h.header_id <> l_header_id
7220: AND NOT EXISTS ( SELECT 1
7221: FROM oe_order_holds_all oh --Modified the query to select from
7222: WHERE h.header_id = oh.header_id --oe_order_holds_all to avoid FTS (SQL#14881293)
7223: AND oh.line_id IS NULL
7224: AND oh.hold_release_id IS NULL )
7225: AND (EXISTS
7226: (SELECT NULL

Line 7265: FROM oe_order_holds_all oh

7261: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7262: AND h.transactional_curr_code = p_curr_code
7263: AND h.header_id <> l_header_id
7264: AND EXISTS ( SELECT 1
7265: FROM oe_order_holds_all oh
7266: WHERE h.header_id = oh.header_id
7267: AND oh.line_id IS NULL
7268: AND oh.hold_release_id IS NULL )
7269: AND (EXISTS

Line 7309: FROM oe_order_holds_all oh

7305: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7306: AND h.transactional_curr_code = p_curr_code
7307: AND h.header_id <> l_header_id
7308: AND EXISTS ( SELECT 1
7309: FROM oe_order_holds_all oh
7310: WHERE h.header_id = oh.header_id
7311: AND oh.line_id IS NULL
7312: AND oh.hold_release_id IS NULL )
7313: AND EXISTS

Line 7349: FROM oe_order_holds_all oh

7345: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7346: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7347: AND h.header_id <> l_header_id
7348: AND NOT EXISTS ( SELECT 1
7349: FROM oe_order_holds_all oh
7350: WHERE h.header_id = oh.header_id
7351: AND oh.line_id IS NULL
7352: AND oh.hold_release_id IS NULL )
7353: AND EXISTS

Line 7390: FROM oe_order_holds_all oh

7386: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7387: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7388: AND h.header_id <> l_header_id
7389: AND NOT EXISTS ( SELECT 1
7390: FROM oe_order_holds_all oh
7391: WHERE h.header_id = oh.header_id
7392: AND oh.line_id IS NULL
7393: AND oh.hold_release_id IS NULL )
7394: AND EXISTS

Line 7430: FROM oe_order_holds_all oh

7426: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7427: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7428: AND h.header_id <> l_header_id
7429: AND EXISTS ( SELECT 1
7430: FROM oe_order_holds_all oh
7431: WHERE h.header_id = oh.header_id
7432: AND oh.line_id IS NULL
7433: AND oh.hold_release_id IS NULL )
7434: AND EXISTS

Line 7470: FROM oe_order_holds_all oh

7466: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7467: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
7468: AND h.header_id <> l_header_id
7469: AND EXISTS ( SELECT 1
7470: FROM oe_order_holds_all oh
7471: WHERE h.header_id = oh.header_id
7472: AND oh.line_id IS NULL
7473: AND oh.hold_release_id IS NULL )
7474: AND EXISTS

Line 7850: FROM oe_order_holds_ALL oh

7846: AND h.booked_flag = 'Y'
7847: AND l.open_flag = 'Y'
7848: AND h.header_id <> l_header_id
7849: AND NOT EXISTS ( SELECT 1
7850: FROM oe_order_holds_ALL oh
7851: WHERE h.header_id = oh.header_id
7852: AND oh.hold_release_id IS NULL )
7853: AND h.transactional_curr_code = p_curr_code
7854: AND (EXISTS

Line 7892: FROM oe_order_holds_ALL oh

7888: AND h.booked_flag = 'Y'
7889: AND l.open_flag = 'Y'
7890: AND h.header_id <> l_header_id
7891: AND NOT EXISTS ( SELECT 1
7892: FROM oe_order_holds_ALL oh
7893: WHERE h.header_id = oh.header_id
7894: AND oh.hold_release_id IS NULL )
7895: AND h.transactional_curr_code = p_curr_code
7896: AND (EXISTS

Line 7932: FROM oe_order_holds_ALL oh

7928: AND h.booked_flag = 'Y'
7929: AND l.open_flag = 'Y'
7930: AND h.header_id <> l_header_id
7931: AND EXISTS ( SELECT 1
7932: FROM oe_order_holds_ALL oh
7933: WHERE h.header_id = oh.header_id
7934: AND oh.hold_release_id IS NULL )
7935: AND h.transactional_curr_code = p_curr_code
7936: AND (EXISTS

Line 7973: FROM oe_order_holds_ALL oh

7969: AND h.booked_flag = 'Y'
7970: AND l.open_flag = 'Y'
7971: AND h.header_id <> l_header_id
7972: AND EXISTS ( SELECT 1
7973: FROM oe_order_holds_ALL oh
7974: WHERE h.header_id = oh.header_id
7975: AND oh.hold_release_id IS NULL )
7976: AND h.transactional_curr_code = p_curr_code
7977: AND (EXISTS

Line 8191: FROM oe_order_holds_ALL oh

8187: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8188: AND h.transactional_curr_code = p_curr_code
8189: AND h.header_id <> l_header_id
8190: AND NOT EXISTS ( SELECT 1
8191: FROM oe_order_holds_ALL oh
8192: WHERE h.header_id = oh.header_id
8193: AND oh.line_id IS NULL
8194: AND oh.hold_release_id IS NULL )
8195: AND (EXISTS

Line 8240: FROM oe_order_holds_ALL oh

8236: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8237: AND h.transactional_curr_code = p_curr_code
8238: AND h.header_id <> l_header_id
8239: AND NOT EXISTS ( SELECT 1
8240: FROM oe_order_holds_ALL oh
8241: WHERE h.header_id = oh.header_id
8242: AND oh.line_id IS NULL
8243: AND oh.hold_release_id IS NULL )
8244: AND (EXISTS

Line 8288: FROM oe_order_holds_ALL oh

8284: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8285: AND h.transactional_curr_code = p_curr_code
8286: AND h.header_id <> l_header_id
8287: AND EXISTS ( SELECT 1
8288: FROM oe_order_holds_ALL oh
8289: WHERE h.header_id = oh.header_id
8290: AND oh.line_id IS NULL
8291: AND oh.hold_release_id IS NULL )
8292: AND (EXISTS

Line 8337: FROM oe_order_holds_ALL oh

8333: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8334: AND h.transactional_curr_code = p_curr_code
8335: AND h.header_id <> l_header_id
8336: AND EXISTS ( SELECT 1
8337: FROM oe_order_holds_ALL oh
8338: WHERE h.header_id = oh.header_id
8339: AND oh.line_id IS NULL
8340: AND oh.hold_release_id IS NULL )
8341: AND (EXISTS

Line 8377: FROM oe_order_holds_ALL oh

8373: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8374: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8375: AND h.header_id <> l_header_id
8376: AND NOT EXISTS ( SELECT 1
8377: FROM oe_order_holds_ALL oh
8378: WHERE h.header_id = oh.header_id
8379: AND oh.line_id IS NULL
8380: AND oh.hold_release_id IS NULL )
8381: AND EXISTS

Line 8422: FROM oe_order_holds_ALL oh

8418: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8419: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8420: AND h.header_id <> l_header_id
8421: AND NOT EXISTS ( SELECT 1
8422: FROM oe_order_holds_ALL oh
8423: WHERE h.header_id = oh.header_id
8424: AND oh.line_id IS NULL
8425: AND oh.hold_release_id IS NULL )
8426: AND EXISTS

Line 8465: FROM oe_order_holds_ALL oh

8461: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8462: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8463: AND h.header_id <> l_header_id
8464: AND EXISTS ( SELECT 1
8465: FROM oe_order_holds_ALL oh
8466: WHERE h.header_id = oh.header_id
8467: AND oh.line_id IS NULL
8468: AND oh.hold_release_id IS NULL )
8469: AND EXISTS

Line 8509: FROM oe_order_holds_ALL oh

8505: AND p.list_line_type_code = 'FREIGHT_CHARGE'
8506: AND (p.invoiced_flag IS NULL OR p.invoiced_flag = 'N')
8507: AND h.header_id <> l_header_id
8508: AND EXISTS ( SELECT 1
8509: FROM oe_order_holds_ALL oh
8510: WHERE h.header_id = oh.header_id
8511: AND oh.line_id IS NULL
8512: AND oh.hold_release_id IS NULL )
8513: AND EXISTS