DBA Data[Home] [Help]

APPS.CTO_CONFIG_ITEM_PK dependencies on WIP_FLOW_SCHEDULES

Line 764: from wip_flow_schedules wfs,

760: begin
761:
762: select wip_entity_id
763: into lWipEntityId
764: from wip_flow_schedules wfs,
765: oe_order_lines_all oel,
766: oe_order_headers_all oeh,
767: oe_transaction_types_all ota,
768: oe_transaction_types_tl otl,

Line 802: xTableName := 'WIP_FLOW_SCHEDULES';

798:
799: when others then
800: xErrorMessage := 'ERROR: Flow Schedule exists for this line, Cannot delink';
801: xMessageName := 'CTO_DELINK_ITEM_ERROR';
802: xTableName := 'WIP_FLOW_SCHEDULES';
803: return(false);
804:
805: end flow_schedule_exists;
806:

Line 1128: from wip_flow_schedules

1124: -- 2784045 : This 'if' condition is decoupled from flow_sch_exist to make the code more efficient
1125: if ( lcfm_routing_flag = 1 ) then
1126: select count(*)
1127: into lflow_schedule_exist
1128: from wip_flow_schedules
1129: where demand_source_line = to_char(lConfigLineId)
1130: and primary_item_id = pConfigid
1131: and demand_source_type = 2 ;
1132: