DBA Data[Home] [Help]

APPS.PO_POXRCPPV_XMLP_PKG dependencies on STANDARD

Line 88: AND wt.standard_rate_flag=1

84:
85: if P_wip_status = 'I' then
86: return(
87: 'AND rct.transaction_id=wt.rcv_transaction_id
88: AND wt.standard_rate_flag=1
89: AND wt.transaction_type = 3
90: AND exists (select 1 from wip_transaction_accounts wta
91: where wta.transaction_id = wt.transaction_id
92: and wta.accounting_line_type = 6)' );

Line 105: 'wt.standard_resource_rate * decode(msi.outside_operation_uom_type,'||'''ASSEMBLY'''||', decode(wt.usage_rate_or_amount,0,1,wt.usage_rate_or_amount), 1)');

101: wip_status VARCHAR2(1);
102: begin
103: if P_wip_status = 'I' then
104: return(
105: 'wt.standard_resource_rate * decode(msi.outside_operation_uom_type,'||'''ASSEMBLY'''||', decode(wt.usage_rate_or_amount,0,1,wt.usage_rate_or_amount), 1)');
106: end if;
107:
108: --RETURN NULL;
109: RETURN null;