VIEW: APPS.QPR_SR_PF_HIER_V

Source

View Text - Preformatted

SELECT distinct child.inventory_item_id , child.concatenated_segments , child_tl.description , null, null, null, null, nvl(parent.concatenated_segments, qpr_sr_util.get_null_pk) , nvl( parent.description, qpr_sr_util.get_null_pk) , null, null, null, null, null, qpr_sr_util.get_all_prd_pk, qpr_sr_util.get_all_prd_desc , null, null, null, null, null, qpr_sr_util.get_max_date( qpr_sr_util.get_max_date( qpr_sr_util.get_max_date( qpr_sr_util.get_max_date(trunc(child.last_update_date, 'dd'), trunc(child_tl.last_update_date, 'dd')), trunc(parent.last_update_date, 'dd')), trunc(bicv.last_update_date, 'dd')), trunc(bbomv.last_update_date, 'dd')) FROM mtl_system_items_kfv child, mtl_system_items_tl child_tl, mtl_system_items_kfv parent, bom_inventory_components bicv, bom_bill_of_materials bbomv WHERE child.inventory_item_id = child_tl.inventory_item_id AND child.organization_id = child_tl.organization_id AND child_tl.LANGUAGE = userenv('LANG') AND child.organization_id = (fnd_profile.value('QPR_MASTER_ORG')) AND child.customer_order_flag = 'Y' AND bbomv.bill_sequence_id = bicv.bill_sequence_id AND bicv.component_item_id = child.inventory_item_id AND bbomv.organization_id = child.organization_id AND bbomv.organization_id = parent.organization_id AND bbomv.assembly_item_id = parent.inventory_item_id AND parent.bom_item_type = 5

View Text - HTML Formatted

SELECT DISTINCT CHILD.INVENTORY_ITEM_ID
, CHILD.CONCATENATED_SEGMENTS
, CHILD_TL.DESCRIPTION
, NULL
, NULL
, NULL
, NULL
, NVL(PARENT.CONCATENATED_SEGMENTS
, QPR_SR_UTIL.GET_NULL_PK)
, NVL( PARENT.DESCRIPTION
, QPR_SR_UTIL.GET_NULL_PK)
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_ALL_PRD_PK
, QPR_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, QPR_SR_UTIL.GET_MAX_DATE( QPR_SR_UTIL.GET_MAX_DATE( QPR_SR_UTIL.GET_MAX_DATE( QPR_SR_UTIL.GET_MAX_DATE(TRUNC(CHILD.LAST_UPDATE_DATE
, 'DD')
, TRUNC(CHILD_TL.LAST_UPDATE_DATE
, 'DD'))
, TRUNC(PARENT.LAST_UPDATE_DATE
, 'DD'))
, TRUNC(BICV.LAST_UPDATE_DATE
, 'DD'))
, TRUNC(BBOMV.LAST_UPDATE_DATE
, 'DD'))
FROM MTL_SYSTEM_ITEMS_KFV CHILD
, MTL_SYSTEM_ITEMS_TL CHILD_TL
, MTL_SYSTEM_ITEMS_KFV PARENT
, BOM_INVENTORY_COMPONENTS BICV
, BOM_BILL_OF_MATERIALS BBOMV
WHERE CHILD.INVENTORY_ITEM_ID = CHILD_TL.INVENTORY_ITEM_ID
AND CHILD.ORGANIZATION_ID = CHILD_TL.ORGANIZATION_ID
AND CHILD_TL.LANGUAGE = USERENV('LANG')
AND CHILD.ORGANIZATION_ID = (FND_PROFILE.VALUE('QPR_MASTER_ORG'))
AND CHILD.CUSTOMER_ORDER_FLAG = 'Y'
AND BBOMV.BILL_SEQUENCE_ID = BICV.BILL_SEQUENCE_ID
AND BICV.COMPONENT_ITEM_ID = CHILD.INVENTORY_ITEM_ID
AND BBOMV.ORGANIZATION_ID = CHILD.ORGANIZATION_ID
AND BBOMV.ORGANIZATION_ID = PARENT.ORGANIZATION_ID
AND BBOMV.ASSEMBLY_ITEM_ID = PARENT.INVENTORY_ITEM_ID
AND PARENT.BOM_ITEM_TYPE = 5