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_CNCL_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 735


    IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
	  AND  p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
    THEN

	  SELECT SOLD_TO_ORG_ID
	  INTO l_sold_to_org_id
	  FROM OE_ORDER_HEADERS
	  WHERE HEADER_ID = p_x_header_rec.header_id;

Line: 2101


	   SELECT SOLD_TO_ORG_ID
	   INTO l_sold_to_org_id
	   FROM OE_ORDER_HEADERS
	   WHERE HEADER_ID = p_x_line_rec.header_id;

Line: 2106


      ELSIF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

	   SELECT SOLD_TO_ORG_ID
	   INTO l_sold_to_org_id
	   FROM OE_ORDER_LINES
	   WHERE LINE_ID = p_x_line_rec.line_id;

Line: 2263


    IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE
	  AND ( p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM
	       OR p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM
	       OR p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM )
    THEN

	  SELECT SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID
	  INTO l_sold_to_org_id, l_invoice_to_org_id, l_deliver_to_org_id
	  FROM OE_ORDER_LINES
	  WHERE LINE_ID = p_x_line_rec.line_id;

Line: 3170


    IF p_x_header_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        p_x_header_rec.last_updated_by := NULL;

Line: 3174


    IF p_x_header_rec.last_update_date = FND_API.G_MISS_DATE THEN
        p_x_header_rec.last_update_date := NULL;

Line: 3178


    IF p_x_header_rec.last_update_login = FND_API.G_MISS_NUM THEN
        p_x_header_rec.last_update_login := NULL;

Line: 3254


    IF p_x_header_rec.program_update_date = FND_API.G_MISS_DATE THEN
        p_x_header_rec.program_update_date := NULL;

Line: 3732


    IF p_x_line_rec.auto_selected_quantity = FND_API.G_MISS_NUM THEN
        p_x_line_rec.auto_selected_quantity := NULL;

Line: 4202


    IF p_x_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        p_x_line_rec.last_updated_by := NULL;

Line: 4206


    IF p_x_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
        p_x_line_rec.last_update_date := NULL;

Line: 4210


    IF p_x_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
        p_x_line_rec.last_update_login := NULL;

Line: 4401


    IF p_x_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
        p_x_line_rec.program_update_date := NULL;

Line: 4995


    IF l_Header_Adj_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Header_Adj_rec.last_update_date := NULL;

Line: 4999


    IF l_Header_Adj_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Header_Adj_rec.last_updated_by := NULL;

Line: 5003


    IF l_Header_Adj_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Header_Adj_rec.last_update_login := NULL;

Line: 5015


    IF l_Header_Adj_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_Header_Adj_rec.program_update_date := NULL;

Line: 5138


    IF l_Header_Adj_rec.updated_flag = FND_API.G_MISS_CHAR THEN
        l_Header_Adj_rec.updated_flag := NULL;

Line: 5142


    IF l_Header_Adj_rec.update_allowed = FND_API.G_MISS_CHAR THEN
        l_Header_Adj_rec.update_allowed := NULL;

Line: 5481


    IF p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG = FND_API.G_MISS_CHAR THEN
      p_x_Header_Scredit_rec.DW_UPDATE_ADVICE_FLAG := NULL;

Line: 5490


    IF p_x_Header_Scredit_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
      p_x_Header_Scredit_rec.LAST_UPDATED_BY := NULL;

Line: 5494


    IF p_x_Header_Scredit_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
      p_x_Header_Scredit_rec.LAST_UPDATE_DATE := NULL;

Line: 5499


    IF p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
      p_x_Header_Scredit_rec.LAST_UPDATE_LOGIN := NULL;

Line: 5533


    IF p_x_Header_Scredit_rec.WH_UPDATE_DATE = FND_API.G_MISS_DATE THEN
      p_x_Header_Scredit_rec.WH_UPDATE_DATE := NULL;

Line: 5585


    IF l_Line_Adj_rec.last_update_date = FND_API.G_MISS_DATE THEN
        l_Line_Adj_rec.last_update_date := NULL;

Line: 5589


    IF l_Line_Adj_rec.last_updated_by = FND_API.G_MISS_NUM THEN
        l_Line_Adj_rec.last_updated_by := NULL;

Line: 5593


    IF l_Line_Adj_rec.last_update_login = FND_API.G_MISS_NUM THEN
        l_Line_Adj_rec.last_update_login := NULL;

Line: 5605


    IF l_Line_Adj_rec.program_update_date = FND_API.G_MISS_DATE THEN
        l_Line_Adj_rec.program_update_date := NULL;

Line: 5720


    IF l_Line_Adj_rec.updated_flag = FND_API.G_MISS_CHAR THEN
	   l_Line_Adj_rec.updated_flag := NULL;

Line: 5724


	IF l_Line_Adj_rec.update_allowed = FND_API.G_MISS_CHAR THEN
	    l_Line_Adj_rec.update_allowed := NULL;

Line: 6067


    IF p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG = FND_API.G_MISS_CHAR THEN
      p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := NULL;

Line: 6076


    IF p_x_Line_Scredit_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN

      p_x_Line_Scredit_rec.LAST_UPDATED_BY := NULL;

Line: 6081


    IF p_x_Line_Scredit_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
      p_x_Line_Scredit_rec.LAST_UPDATE_DATE := NULL;

Line: 6086


    IF p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
      p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := NULL;

Line: 6121


    IF p_x_Line_Scredit_rec.WH_UPDATE_DATE = FND_API.G_MISS_DATE THEN

      p_x_Line_Scredit_rec.WH_UPDATE_DATE := NULL;