VIEW: APPS.AST_PURCH_LINES_V

Source

View Text - Preformatted

SELECT ll.lead_line_id , ll.lead_id , ll.interest_type_id , ll.primary_interest_code_id , ll.secondary_interest_code_id , ll.interest_status_code , ll.inventory_item_id , ll.organization_id , ll.uom_code , ll.quantity , ll.ship_date , ll.total_amount , ll.quoted_line_flag , ll.original_lead_line_id , inttype.interest_type , pic.code, sic.code , ll.price , ll.price_volume_margin , sic.pf_item_id , sic.pf_organization_id FROM AS_INTEREST_CODES_VL PIC, AS_INTEREST_CODES_VL SIC, AS_INTEREST_TYPES_VL INTTYPE, AS_LEAD_LINES LL WHERE ll.primary_interest_code_id = pic.interest_code_id(+) and ll.secondary_interest_code_id = sic.interest_code_id(+) and ll.interest_type_id = inttype.interest_type_id(+)

View Text - HTML Formatted

SELECT LL.LEAD_LINE_ID
, LL.LEAD_ID
, LL.INTEREST_TYPE_ID
, LL.PRIMARY_INTEREST_CODE_ID
, LL.SECONDARY_INTEREST_CODE_ID
, LL.INTEREST_STATUS_CODE
, LL.INVENTORY_ITEM_ID
, LL.ORGANIZATION_ID
, LL.UOM_CODE
, LL.QUANTITY
, LL.SHIP_DATE
, LL.TOTAL_AMOUNT
, LL.QUOTED_LINE_FLAG
, LL.ORIGINAL_LEAD_LINE_ID
, INTTYPE.INTEREST_TYPE
, PIC.CODE
, SIC.CODE
, LL.PRICE
, LL.PRICE_VOLUME_MARGIN
, SIC.PF_ITEM_ID
, SIC.PF_ORGANIZATION_ID
FROM AS_INTEREST_CODES_VL PIC
, AS_INTEREST_CODES_VL SIC
, AS_INTEREST_TYPES_VL INTTYPE
, AS_LEAD_LINES LL
WHERE LL.PRIMARY_INTEREST_CODE_ID = PIC.INTEREST_CODE_ID(+)
AND LL.SECONDARY_INTEREST_CODE_ID = SIC.INTEREST_CODE_ID(+)
AND LL.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID(+)