DBA Data[Home] [Help]

APPS.CTO_CHANGE_ORDER_PK dependencies on CTO_WORKBENCH_UTIL_PK

Line 1503: AND demand_source_type_id = DECODE(CTO_WORKBENCH_UTIL_PK.get_source_document_id(p_line_id), 10,8,2)

1499: mfg_lookups mlk,
1500: mfg_lookups mlk2,
1501: oe_order_lines_all oel
1502: WHERE oel.line_id = p_line_id
1503: AND demand_source_type_id = DECODE(CTO_WORKBENCH_UTIL_PK.get_source_document_id(p_line_id), 10,8,2)
1504: AND oel.line_id = mr.demand_source_line_id
1505: AND mr.supply_source_type_id = 5
1506: AND wdj.wip_entity_id = mr.supply_source_header_id
1507: AND wdj.organization_id = mr.organization_id