[Home] [Help]
4116: CSP_PRODUCT_TASKS a,
4117: CSP_TASK_PARTS b,
4118: QP_PRICE_LIST_LINES_V c,
4119: MTL_SYSTEM_ITEMS_KFV d,
4120: CSD_REPAIR_TYPES_SAR e,
4121: CS_TXN_BILLING_TYPES f,
4122: JTF_TASK_TEMPLATES_VL g
4123: WHERE ROSC.repair_line_id = p_repair_line_id
4124: and ROSC.applicable_flag = 'Y'
4170: CSD_SC_WORK_ENTITIES WRK,
4171: JTF_TASK_TEMPLATES_B b,
4172: QP_PRICE_LIST_LINES_V c,
4173: MTL_SYSTEM_ITEMS_KFV d,
4174: CSD_REPAIR_TYPES_SAR e,
4175: CS_TXN_BILLING_TYPES f,
4176: JTF_TASK_TEMPLATES_VL g
4177: WHERE ROSC.repair_line_id = p_repair_line_id
4178: and ROSC.applicable_flag = 'Y'
4229: csp_product_tasks a,
4230: csp_task_parts b,
4231: qp_price_list_lines_v c,
4232: mtl_system_items_kfv d,
4233: csd_repair_types_sar e,
4234: cs_txn_billing_types f,
4235: jtf_task_templates_vl g
4236: WHERE
4237: g.task_group_id = JtfTaskTempGroupEO.task_template_group_id
4294: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4295: jtf_task_templates_b b,
4296: qp_price_list_lines_v c,
4297: mtl_system_items_kfv d,
4298: csd_repair_types_sar e,
4299: cs_txn_billing_types f,
4300: jtf_task_templates_vl g
4301: WHERE
4302: SetLinkRO.other_id = p_repair_line_id
4355: CSP_PRODUCT_TASKS a,
4356: CSP_TASK_PARTS b,
4357: -- QP_PRICE_LIST_LINES_V c,
4358: MTL_SYSTEM_ITEMS_KFV d,
4359: CSD_REPAIR_TYPES_SAR e,
4360: CS_TXN_BILLING_TYPES f,
4361: JTF_TASK_TEMPLATES_VL g
4362: WHERE ROSC.repair_line_id = p_repair_line_id
4363: AND ROSC.applicable_flag = 'Y'
4410: CSD_SC_WORK_ENTITIES WRK,
4411: JTF_TASK_TEMPLATES_B b,
4412: -- QP_PRICE_LIST_LINES_V c,
4413: MTL_SYSTEM_ITEMS_KFV d,
4414: CSD_REPAIR_TYPES_SAR e,
4415: CS_TXN_BILLING_TYPES f,
4416: JTF_TASK_TEMPLATES_VL g
4417: WHERE ROSC.repair_line_id = p_repair_line_id
4418: AND ROSC.applicable_flag = 'Y'
4466: csp_product_tasks a,
4467: csp_task_parts b,
4468: -- qp_price_list_lines_v c,
4469: mtl_system_items_kfv d,
4470: CSD_REPAIR_TYPES_SAR e,
4471: cs_txn_billing_types f,
4472: jtf_task_templates_vl g
4473: WHERE g.task_group_id =
4474: JtfTaskTempGroupEO.task_template_group_id
4530: jtf_task_temp_groups_vl JtfTaskTempGroupEO,
4531: jtf_task_templates_b b,
4532: -- qp_price_list_lines_v c,
4533: mtl_system_items_kfv d,
4534: CSD_REPAIR_TYPES_SAR e,
4535: cs_txn_billing_types f,
4536: jtf_task_templates_vl g
4537: WHERE SetLinkRO.other_id = p_repair_line_id
4538: AND SetLinkRO.object_code = 'DR'
5364: CSD_SC_WORK_ENTITIES WRK,
5365: BOM_INVENTORY_COMPONENTS_V BOM,
5366: QP_PRICE_LIST_LINES_V PRICE,
5367: MTL_SYSTEM_ITEMS_KFV MTL,
5368: CSD_REPAIR_TYPES_SAR RTSAR,
5369: CS_TXN_BILLING_TYPES SAR
5370: WHERE ROSC.repair_line_id = p_repair_line_id
5371: and ROSC.applicable_flag = 'Y'
5372: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5416: BOM_OPERATION_SEQUENCES OPSEQ,
5417: BOM_OPERATION_RESOURCES OPRES,
5418: QP_PRICE_LIST_LINES_V PRICE,
5419: MTL_SYSTEM_ITEMS_KFV MTL,
5420: CSD_REPAIR_TYPES_SAR RTSAR,
5421: CS_TXN_BILLING_TYPES SAR,
5422: BOM_RESOURCES RES
5423: WHERE ROSC.repair_line_id = p_repair_line_id
5424: and ROSC.applicable_flag = 'Y'
5467: CSD_SC_WORK_ENTITIES WRK,
5468: BOM_INVENTORY_COMPONENTS_V BOM,
5469: -- QP_PRICE_LIST_LINES_V PRICE,
5470: MTL_SYSTEM_ITEMS_KFV MTL,
5471: CSD_REPAIR_TYPES_SAR RTSAR,
5472: CS_TXN_BILLING_TYPES SAR
5473: WHERE ROSC.repair_line_id = p_repair_line_id
5474: AND ROSC.applicable_flag = 'Y'
5475: -- and ROSC.applied_to_work_flag = 'N' -- bugfix 3473869.vkjain.
5518: BOM_OPERATION_SEQUENCES OPSEQ,
5519: BOM_OPERATION_RESOURCES OPRES,
5520: -- QP_PRICE_LIST_LINES_V PRICE,
5521: MTL_SYSTEM_ITEMS_KFV MTL,
5522: CSD_REPAIR_TYPES_SAR RTSAR,
5523: CS_TXN_BILLING_TYPES SAR,
5524: BOM_RESOURCES RES
5525: WHERE ROSC.repair_line_id = p_repair_line_id
5526: AND ROSC.applicable_flag = 'Y'