APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on STANDARD

Line 585: ,STANDARD_OPERATION_ID

581: ,COMMON_ROUTING_SEQ_ID
582: ,ORG_COST_GROUP_ID
583: ,COST_TYPE_ID
584: ,TRANSACTION_STATUS
585: ,STANDARD_OPERATION_ID
586: ,TASK_PRIORITY
587: ,WMS_TASK_TYPE
588: ,PARENT_LINE_ID
589: ,LPN_ID

Line 819: ,STANDARD_OPERATION_ID

815: ,COMMON_ROUTING_SEQ_ID
816: ,ORG_COST_GROUP_ID
817: ,COST_TYPE_ID
818: ,TRANSACTION_STATUS
819: ,STANDARD_OPERATION_ID
820: ,TASK_PRIORITY
821: ,WMS_TASK_TYPE
822: ,decode(PARENT_LINE_ID, NULL,NULL,l_new_txn_temp_id) -- Take care of BULK parent
823: ,NULL

Line 3714: , t.standard_operation_id

3710: --Step0 Get reources information
3711: -- Picking or Replenishment task
3712: SELECT bremp.resource_id role_id
3713: , t.wms_task_type
3714: , t.standard_operation_id
3715: , t.operation_plan_id
3716: INTO l_per_res_id
3717: , l_wms_task_type
3718: , l_std_op_id

Line 3722: AND t.standard_operation_id = bsor.standard_operation_id

3718: , l_std_op_id
3719: , l_operation_plan_id
3720: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
3721: WHERE t.transaction_temp_id = l_rec.task_id
3722: AND t.standard_operation_id = bsor.standard_operation_id
3723: AND bsor.resource_id = bremp.resource_id
3724: AND bremp.resource_type = 2
3725: AND ROWNUM < 2;
3726: --Added for bug#8721738 start