DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on WIP_FLOW_SCHEDULES

Line 689: from wip_flow_schedules wfs,

685: begin
686:
687: select wip_entity_id
688: into lWipEntityId
689: from wip_flow_schedules wfs,
690: oe_order_lines_all oel,
691: oe_order_headers_all oeh,
692: oe_transaction_types_all ota,
693: oe_transaction_types_tl otl,

Line 727: xTableName := 'WIP_FLOW_SCHEDULES';

723:
724: when others then
725: xErrorMessage := 'ERROR: Flow Schedule exists for this line, Cannot delink';
726: xMessageName := 'CTO_DELINK_ITEM_ERROR';
727: xTableName := 'WIP_FLOW_SCHEDULES';
728: return(false);
729:
730: end flow_schedule_exists;
731:

Line 1049: from wip_flow_schedules

1045: -- 2784045 : This 'if' condition is decoupled from flow_sch_exist to make the code more efficient
1046: if ( lcfm_routing_flag = 1 ) then
1047: select count(*)
1048: into lflow_schedule_exist
1049: from wip_flow_schedules
1050: where demand_source_line = to_char(lConfigLineId)
1051: and primary_item_id = pConfigid
1052: and demand_source_type = 2 ;
1053: