VIEW: APPS.JTM_CSF_DEBRIEF_LINES_V

Source

View Text - Preformatted

SELECT JDL.ACCESS_ID , DBL.DEBRIEF_LINE_ID , DBL.DEBRIEF_HEADER_ID , DBL.DEBRIEF_LINE_NUMBER , DBL.SERVICE_DATE , DBL.TXN_BILLING_TYPE_ID , DBL.INVENTORY_ITEM_ID , DBL.ISSUING_INVENTORY_ORG_ID , DBL.RECEIVING_INVENTORY_ORG_ID , DBL.ISSUING_SUB_INVENTORY_CODE , DBL.RECEIVING_SUB_INVENTORY_CODE , DBL.ISSUING_LOCATOR_ID , DBL.RECEIVING_LOCATOR_ID , DBL.PARENT_PRODUCT_ID , DBL.REMOVED_PRODUCT_ID , DBL.STATUS_OF_RECEIVED_PART , DBL.ITEM_SERIAL_NUMBER , DBL.ITEM_REVISION , DBL.ITEM_LOTNUMBER , DBL.UOM_CODE , DBL.QUANTITY , DBL.RMA_HEADER_ID , DBL.DISPOSITION_CODE , DBL.MATERIAL_REASON_CODE , DBL.LABOR_REASON_CODE , DBL.EXPENSE_REASON_CODE , DBL.LABOR_START_DATE , DBL.LABOR_END_DATE , DBL.STARTING_MILEAGE , DBL.ENDING_MILEAGE , DBL.EXPENSE_AMOUNT , DBL.CURRENCY_CODE , DBL.DEBRIEF_LINE_STATUS_ID , DBL.CHANNEL_CODE , DBL.CHARGE_UPLOAD_STATUS , DBL.CHARGE_UPLOAD_MSG_CODE , DBL.CHARGE_UPLOAD_MESSAGE , DBL.IB_UPDATE_STATUS , DBL.IB_UPDATE_MSG_CODE , DBL.IB_UPDATE_MESSAGE , DBL.SPARE_UPDATE_STATUS , DBL.SPARE_UPDATE_MSG_CODE , DBL.SPARE_UPDATE_MESSAGE , DBL.BUSINESS_PROCESS_ID , DBL.INSTANCE_ID , DBL.TRANSACTION_TYPE_ID , DBL.RETURN_REASON_CODE , DBL.ATTRIBUTE_CATEGORY , DBL.ATTRIBUTE1 , DBL.ATTRIBUTE2 , DBL.ATTRIBUTE3 , DBL.ATTRIBUTE4 , DBL.ATTRIBUTE5 , DBL.ATTRIBUTE6 , DBL.ATTRIBUTE7 , DBL.ATTRIBUTE8 , DBL.ATTRIBUTE9 , DBL.ATTRIBUTE10 , DBL.ATTRIBUTE11 , DBL.ATTRIBUTE12 , DBL.ATTRIBUTE13 , DBL.ATTRIBUTE14 , DBL.ATTRIBUTE15 FROM CSF_DEBRIEF_LINES DBL , JTM_CSF_DEBRIEF_LINES_ACC JDL WHERE DBL.DEBRIEF_LINE_ID = JDL.DEBRIEF_LINE_ID AND JDL.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT JDL.ACCESS_ID
, DBL.DEBRIEF_LINE_ID
, DBL.DEBRIEF_HEADER_ID
, DBL.DEBRIEF_LINE_NUMBER
, DBL.SERVICE_DATE
, DBL.TXN_BILLING_TYPE_ID
, DBL.INVENTORY_ITEM_ID
, DBL.ISSUING_INVENTORY_ORG_ID
, DBL.RECEIVING_INVENTORY_ORG_ID
, DBL.ISSUING_SUB_INVENTORY_CODE
, DBL.RECEIVING_SUB_INVENTORY_CODE
, DBL.ISSUING_LOCATOR_ID
, DBL.RECEIVING_LOCATOR_ID
, DBL.PARENT_PRODUCT_ID
, DBL.REMOVED_PRODUCT_ID
, DBL.STATUS_OF_RECEIVED_PART
, DBL.ITEM_SERIAL_NUMBER
, DBL.ITEM_REVISION
, DBL.ITEM_LOTNUMBER
, DBL.UOM_CODE
, DBL.QUANTITY
, DBL.RMA_HEADER_ID
, DBL.DISPOSITION_CODE
, DBL.MATERIAL_REASON_CODE
, DBL.LABOR_REASON_CODE
, DBL.EXPENSE_REASON_CODE
, DBL.LABOR_START_DATE
, DBL.LABOR_END_DATE
, DBL.STARTING_MILEAGE
, DBL.ENDING_MILEAGE
, DBL.EXPENSE_AMOUNT
, DBL.CURRENCY_CODE
, DBL.DEBRIEF_LINE_STATUS_ID
, DBL.CHANNEL_CODE
, DBL.CHARGE_UPLOAD_STATUS
, DBL.CHARGE_UPLOAD_MSG_CODE
, DBL.CHARGE_UPLOAD_MESSAGE
, DBL.IB_UPDATE_STATUS
, DBL.IB_UPDATE_MSG_CODE
, DBL.IB_UPDATE_MESSAGE
, DBL.SPARE_UPDATE_STATUS
, DBL.SPARE_UPDATE_MSG_CODE
, DBL.SPARE_UPDATE_MESSAGE
, DBL.BUSINESS_PROCESS_ID
, DBL.INSTANCE_ID
, DBL.TRANSACTION_TYPE_ID
, DBL.RETURN_REASON_CODE
, DBL.ATTRIBUTE_CATEGORY
, DBL.ATTRIBUTE1
, DBL.ATTRIBUTE2
, DBL.ATTRIBUTE3
, DBL.ATTRIBUTE4
, DBL.ATTRIBUTE5
, DBL.ATTRIBUTE6
, DBL.ATTRIBUTE7
, DBL.ATTRIBUTE8
, DBL.ATTRIBUTE9
, DBL.ATTRIBUTE10
, DBL.ATTRIBUTE11
, DBL.ATTRIBUTE12
, DBL.ATTRIBUTE13
, DBL.ATTRIBUTE14
, DBL.ATTRIBUTE15
FROM CSF_DEBRIEF_LINES DBL
, JTM_CSF_DEBRIEF_LINES_ACC JDL
WHERE DBL.DEBRIEF_LINE_ID = JDL.DEBRIEF_LINE_ID
AND JDL.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID