[Home] [Help]
1708: msi.segment1 INVENTORY_ITEM_NAME,
1709: msi.description INVENTORY_ITEM_DESCRIPTION
1710: FROM okc_k_items item,
1711: okc_k_lines_b cleb_item,
1712: MTL_SYSTEM_ITEMS_B msi
1713: WHERE item.cle_id = cleb_item.id
1714: AND cleb_item.lse_id = 34
1715: AND msi.inventory_item_id = item.object1_id1
1716: AND msi.organization_id = item.object1_id2) item_line,
1866: lookup_usage.meaning USAGE_TYPE
1867: FROM
1868: OKC_RULES_B RUL,
1869: OKC_RULE_GROUPS_B RG,
1870: mtl_system_items_b mtl,
1871: mtl_system_items_tl mtl_tl,
1872: OKX_LIST_HEADERS_V OKX_PRICE,
1873: OKC_K_LINES_B CLE,
1874: fnd_lookup_values_vl lookup_read,
3820: msi.segment1 INVENTORY_ITEM_NAME,
3821: msi.description INVENTORY_ITEM_DESCRIPTION
3822: FROM okc_k_items item,
3823: okc_k_lines_b cleb_item,
3824: MTL_SYSTEM_ITEMS_B msi
3825: WHERE item.cle_id = cleb_item.id
3826: AND cleb_item.lse_id = 34
3827: AND msi.inventory_item_id = item.object1_id1
3828: AND msi.organization_id = item.object1_id2) item_line,
3970: lookup_usage.meaning USAGE_TYPE
3971: FROM
3972: OKC_RULES_B RUL,
3973: OKC_RULE_GROUPS_B RG,
3974: mtl_system_items_b mtl,
3975: mtl_system_items_tl mtl_tl,
3976: OKX_LIST_HEADERS_V OKX_PRICE,
3977: OKC_K_LINES_B CLE,
3978: fnd_lookup_values_vl lookup_read,
5801: msi.segment1 INVENTORY_ITEM_NAME,
5802: msi.description INVENTORY_ITEM_DESCRIPTION
5803: FROM okc_k_items item,
5804: okc_k_lines_b cleb_item,
5805: MTL_SYSTEM_ITEMS_B msi
5806: WHERE item.cle_id = cleb_item.id
5807: AND cleb_item.lse_id = 34
5808: AND msi.inventory_item_id = item.object1_id1
5809: AND msi.organization_id = item.object1_id2) item_line,
6006: lookup_usage.meaning USAGE_TYPE
6007: FROM
6008: OKC_RULES_B RUL,
6009: OKC_RULE_GROUPS_B RG,
6010: mtl_system_items_b mtl,
6011: mtl_system_items_tl mtl_tl,
6012: OKX_LIST_HEADERS_V OKX_PRICE,
6013: OKC_K_LINES_B CLE,
6014: fnd_lookup_values_vl lookup_read,