VIEW: APPS.PN_VAR_LINES_DATES_V

Source

View Text - Preformatted

SELECT per.start_date ,per.end_date ,per.period_num ,look.meaning ,look1.meaning ,varent_dates.invg_freq_code ,varent_dates.recon_freq_code ,varent_dates.reptg_freq_code ,varent_dates.audit_freq_code ,varent.uom_code ,varent.rent_num ,lines.line_item_num ,lines.sales_type_code ,lines.item_category_code ,lines.rowid ,lines.line_item_id ,lines.period_id ,lines.last_update_date ,lines.last_updated_by ,lines.creation_date ,lines.created_by ,lines.last_update_login ,varent.org_id FROM FND_LOOKUPS look, FND_LOOKUPS look1, PN_VAR_PERIODS_ALL per, PN_VAR_LINES_ALL lines, PN_VAR_RENT_DATES_ALL varent_dates, PN_VAR_RENTS varent WHERE lines.period_id = per.period_id AND per.var_rent_id = varent.var_rent_id AND varent.var_rent_id = varent_dates.var_rent_id AND look.lookup_type(+) = 'PN_SALES_CHANNEL' AND look.lookup_code(+) = lines.SALES_TYPE_CODE AND look1.lookup_type(+) = 'PN_ITEM_CATEGORY' AND look1.lookup_code(+) = lines.ITEM_CATEGORY_CODE

View Text - HTML Formatted

SELECT PER.START_DATE
, PER.END_DATE
, PER.PERIOD_NUM
, LOOK.MEANING
, LOOK1.MEANING
, VARENT_DATES.INVG_FREQ_CODE
, VARENT_DATES.RECON_FREQ_CODE
, VARENT_DATES.REPTG_FREQ_CODE
, VARENT_DATES.AUDIT_FREQ_CODE
, VARENT.UOM_CODE
, VARENT.RENT_NUM
, LINES.LINE_ITEM_NUM
, LINES.SALES_TYPE_CODE
, LINES.ITEM_CATEGORY_CODE
, LINES.ROWID
, LINES.LINE_ITEM_ID
, LINES.PERIOD_ID
, LINES.LAST_UPDATE_DATE
, LINES.LAST_UPDATED_BY
, LINES.CREATION_DATE
, LINES.CREATED_BY
, LINES.LAST_UPDATE_LOGIN
, VARENT.ORG_ID
FROM FND_LOOKUPS LOOK
, FND_LOOKUPS LOOK1
, PN_VAR_PERIODS_ALL PER
, PN_VAR_LINES_ALL LINES
, PN_VAR_RENT_DATES_ALL VARENT_DATES
, PN_VAR_RENTS VARENT
WHERE LINES.PERIOD_ID = PER.PERIOD_ID
AND PER.VAR_RENT_ID = VARENT.VAR_RENT_ID
AND VARENT.VAR_RENT_ID = VARENT_DATES.VAR_RENT_ID
AND LOOK.LOOKUP_TYPE(+) = 'PN_SALES_CHANNEL'
AND LOOK.LOOKUP_CODE(+) = LINES.SALES_TYPE_CODE
AND LOOK1.LOOKUP_TYPE(+) = 'PN_ITEM_CATEGORY'
AND LOOK1.LOOKUP_CODE(+) = LINES.ITEM_CATEGORY_CODE